Indeed, this is a great example of a fallacy like survivors bias, where you only hear about a tiny percentage of cases because of x, which makes for a poor representation of the entire population.

The vast majority of our interaction with CEO behaviour is via true crime stories and exceptional rare cases. I see Bill Gates and Steve Jobs as rare cases of an executives playing a huge role in their companies but I could list off countless billion dollar company CEOs people have ever heard of, let alone 99%+ companies are small/medium sized, many companies aren’t even public, countless play a much smaller and far more boring role, etc etc.

I imagine we do hear about more such cases because there simply are more of them compared to other groups we hear about.

There's been some notable studies by now that concluded the amount of psychopaths is way higher among CEO's than the average population and that it isn't that exceptionally rare among this subgroup as you said.