I have about 30 years coding experience, never had a manager that was still writing code after earning the position, other than a few Office macros.

It was never an issue to us and they were always respected by the team, except for the few ones that never should have been managers to start with.

Any manager that wants respect from the team needs to support them, specially against stupid decisions from upper layers. Have good social skills and specially important, how to raise morale in darker times.

Knowing to code is irrelevant.