A head coach also has more impact on a team's outcome than many middle managers (but probably not a founder). Managing well is hard and can be a major multiplier, but there is room at many companies to be mediocre or worse (even when trying your best) and still pass. I'm talking mostly functional managers as in Engineering Manager, PMs (most of whom are ICs) are different. Being a functional manager would be more like being the running back coach in football, the big man coach in basketball, or the pitching coach in baseball. These are different than being head coach, they help those players be good at their role, but have much less impact on the team's bigger picture. Winning in this role is seeing a player grow more than it is seeing the team win the championship. These coaches make far less than the head coach and the players.
Ultimately, I think the manager role is diminished by modern org structure. One thing said about a good manager is they block and shield—which implies the report needs protection from the org's process/structure. So a good manager runs counter to the company reasonably often. Is the manager helping or hurting the company? Both I think, but on net I don't know. It feels oddly baked into the role.