I dunno. This is not a garden variety affair. Anyone in our intelligence services committing such an act is open to blackmail.
I think I have to disagree with both you and Ann.
On the one hand, if every adulterer felt too much shame to remain in high-profile positions of authority, I think civilization would be stronger. Accepting personal responsibilities for your shortcomings and thereby setting a higher moral standard for others is never a bad thing.
On the other hand, you only leave yourself open to blackmail if you try to keep it a secret. We all make mistakes, some much bigger than others, the key is to acknowledge them and try to overcome them. It might have ended his marriage, but if he'd told his wife what he'd done he would have eliminated any leverage his mistress had on him.