When you have someone who only makes decision based on outcomes from a black box process with the counter productive passive aggressive nagging of when will it be done vs. someone who understands the stress,emotions (yeah programmers have them too),art and approximate effort management to avoid burning people out will be a godsend.
You can absolutely become the latter without technical expertise, I would say empathy is the biggest tool of someone who manages programmers.
The cigar smoking hunch back Soviet union styled factory owner who keeps saying he survived the dot com bubble like it was some world war and getting angry when programmers are trying to 'subvert' him by intentionally missing deadlines. I think it's good that these type of industrial revolution era work management culture is slowly eroding.
But yeah the disconnect between those on the front lines everyday with headphones on vs. the schmoozing politicizing manager with 30 years of restaurant experience is not going to be a good cultural fit. Eventually, everyone abandons you, people check glassdoor reviews and then you are finished, you can't hire anyone anymore without some insane turnover.