Just anecdotal ofc but over my career having worked for 14 managers.
Half of them were eventually fired.
Most of them sucked at rallying teams, mainly because who the f is going to follow a doofus cringe lord?
2 managers stand out to me in my career. I’m really good friends with one of them that I’ve been in contact with for over a decade now.
Most were basically checkbox checkers who sucked at engineering and faked their way into “people management” only to be found out that they just plain suck as employees. I actually checked LinkedIn just now of a few of those bad ones and they work at small companies and have made no upward progress. Not surprised honestly.
Keep in mind I worked at a pretty good place, not a noob tier place.