The sentiment I've seen is that a great people manager who trusts their engineers despite not knowing much about software can still be an above average manager.
Given that the median manager seems to be throughly mediocre, an above average manager even if they can't code or read code seems desirable.