Ouch. Finally admitted it. Brutal. Bad move by him.
Does it really matter? Not really. Extra marital affairs are common place in our society. Shouldn't have lied and should have some sort of punishment, perhaps not being elected again will be punishment enough.
Don't believe he should resign unless he broke the law.