I've had good software engineering managers who couldn't code anything beyond simple shell scripts.

It's possible to be a great developer manager without having been a developer yourself, but it's much harder and much less common.

In my experience, the managers who excel despite not having an engineering background usually get promoted through the ranks quickly, so you may not see them much anyway. Being able to effectively manage people without completely understanding their work is a valuable (and rare) skill.