The country ignored FDR's serial adulteries. And JFK's skirt chasing...along with lots of other senators and public officials in his day.
The press is now and always has been highly selective about the things that become public knowledge and/or a "scandal". So that's not a terribly good measure.
...and more often than not public officials who are playing sexual games are abusing their office in the process of or in addition to. Doesn't appear so in this case, but this case is relatively rare...a public official who still appears capable of shame and who has a sense of honor. Don't see that too much with the Weiners or Clintons or Spitzers of the world.
Many police departments are ate up with adultery and far worse...the result of people with lots of time on their hands, relatively poor oversight, and an organizational culture where everybody covers for everybody.
Personally I'm not deeply interested in the infidelities of others because I know how common it is for people to step out on one another, and I know that a whole bunch of things can contribute to making that happen.
Unfortunately it often doesn't end there. It would be nice if people kept their bad acts nicely compartmentalized and I know of some people who have done precisely that, nevertheless they seem to be the exception rather than the rule. An example would be a chief LEO in my area who was having multiple affairs...but was also part of a clique that throughout a number of years had warped the integrity of the entire organization by promoting his buddies and ignoring their shortcuts and bad acts in addition to putting his own out there.
It took him being pulled over for DUI to get him out and get in some new blood intent on cleaning things up. The public was largely unaware of this because his clique was a subset of a larger clique of powerful people in the area including the people who own the papers. (Look up the history of the Byrds in Virginia sometime if you want to be sick)
Bad acts that actually do impact the office and the execution of its duties often accompany bad acts that many would regard as a private matter. While it's not an absolute guarantee, it's still true that character defects tend to follow the person who has them regardless of what sphere he/she is operating in.
There's more to it than just social stigmas that are a relic from a puritanical past.