Nobel Prize winner Tim Hunt
Harvard President Lawrence Summers
are the three that immediately come to mind.
Additionally, it’s hard to feel bad for him as the way he “lost his job” was by being offered an extraordinarily prestigious named professorship (see https://en.wikipedia.org/wiki/Harvard_University_Professor), giving him the ability to work on pretty much whatever he wants for the rest of his life, with a great salary, benefits, etc., and with few required duties.
I think he would have been removed (or removed himself) as university president sooner or later regardless given his other political blunders, but it might have taken a few years longer. As I mentioned, the comments about sex differences provided a convenient excuse and rallying point for his critics.
I wouldn’t say he was “terrible” at his job. Naïve, undiplomatic, and bull-headed, with good intentions but without enough political skill to persuade his opponents to follow him or enough empathy to understand their objections and moderate his positions.
Disclaimer: I was a first year undergraduate at the time, and my understanding comes from talking to various people at Harvard during and after the controversy, including both critics and supporters of Summers. I wasn’t well enough connected to be the ideal first-hand source about this topic.