I'll say it depends on the company's business and objectives.

A CTO of a tech company needs to be super technical.

For example in Vercel, even CEO is a technical person.