A good manager is like the coxswain of a row boat. Their job isn’t to provide more power, or tell the rowers how to row. Their job is to keep all the rowers synchronized, and pulling in the same direction.
A good manager does a similar thing. They keep the team both aligned with each other, and pointed in the required business direction. There are a LOT of bad managers out there, however.