This can't be overstated. The best engineer could be the worst manager.

That said, managers should have at least some level of technical knowledge on what they're managing. I'm a security engineer that once worked under a CISO who had very little technical knowledge and it showed. Having to explain things to him multiple times got frustrating. We're talking on the level of "Hey, our nmap scans are showing we have port 443 open on our web app. We should have all ports closed." and then trying to explain why that would make our web app completely inaccessible.