Read the old Dilbert strips to learn everything you should -not- do about being a manager 🤡
Regarding skills, the most important is having keen ears and being good at **understanding **what people want. People might say or write something, but mean another thing, for any reason: malice, lack of knowledge, insecurity, etc. Document as much as possible when it comes to decision making. An email of "Go ahead with X" is the best defense you can have if the project blows.
The manager needs to juggle the team under him and the avalanche of demands coming from elsewhere, so the pressure comes from all sides. The manager becomes "the face" of the team, so whatever the team does becomes his responsibility. The more you see them as a team to be guided/led, instead of servants to be ordered, the better your relation will tend to be with them.