Being good with people is an important part of leadership, but it is not the same as being a good leader.
You can be great with people and still struggle with leadership. And you can be a great leader without naturally being great with people.
At the end of the day, leadership is all about outcomes - making the right decisions, taking responsibility for them, and helping the team get where it needs to go.
Both skills matter. They are just not the same thing.