If “good leader” is in the sense of “somebody who leads others to good outcomes” rather than in the sense of “somebody who is good at leading others”, it does make sense that some who are natural leaders and hence good at leading people don’t actually lead people to the best outcomes or even good outcomes.

History is full of people who naturally inspired others to follow them and then used that for their own personal advantage, ultimatelly screwing their followers.

Just because you’re good at getting people to follow you doesn’t mean you’re good at finding the right path or that you have good intentions towards others.