It is horrifying that world leaders and public figures use this kind of excuse, which is supposed to somehow give a pass, and then we see it trickle down to the man on the street.
Really, the public figures should be prosecuted and made an example of, so that is the example for the average man. Anything less is unacceptable.
Our legal system is not forgiving of people that make mistakes.
"I accidentally fell asleep at the wheel and killed someone" = manslaughter = prison.
What this person did is very wrong, and everyone who does it should be punished, regardless of their obscurity/fame.
One does not go up to someone you owe deference and include the word "fuck" specially given the kinds of allegations and confirmation, in your apology. Understand social convention and understand respect. It's like he's apologizing to one of his "bros".