As a counter example - I was at a startup where all the CEO did was sales. Everything worked really great.
I think the key here is is the culture pathological or not - not the specific role of the CEO. CEO can have good enough understanding of tech to do their job well even thought they are not elbows deep in it themselves.
Culture is important, but I think direction might be even more key.
If "sales" means "I spent 3 years talking to every customer in a particular industry, became keenly aware of a vacant niche, and now am looking to do something about it" I reckon it would be a very good thing.
If "sales" means "I saw that the crypto market is booming and want to get in on the easy money," it's not going to go well.
I think the key here is is the culture pathological or not - not the specific role of the CEO. CEO can have good enough understanding of tech to do their job well even thought they are not elbows deep in it themselves.