I have worked with a few CEOs like this; the last was an old company (25 years) in dire need of a digital transformation to survive. The company had more than 300 employees and was still using Excel and Lotus Notes on-prem server room. I started a move to Office365 and Azure Cloud .NET, but the CEO showed no interest in the technology and gave me a few months to complete the transition. He came up with some unrealistic ideas for accomplishing the move when timescales were not met.
After a year, I left the company after delivering a few things. Recently, I visited their website and found only a single home page with several PDF documents embedded within it and no sign of any client-facing solution. Assume they are back in Excel again.
There are plenty of CEOs / Founders out there that would love to find a great CTO / CIO so don't give up looking :)
My advice is to start looking for a new job or go freelance. I started doing fractional CTO work - which is interesting but challenging to find new clients.