Well sure. CEOs' main job is to coordinate the functions of major business units with the wishes of shareholders/the board of directors. Ultimately they're a middleman on the hook for the results of the business without actual direct control of day to day operations.
Effectively that means they give broad goals and direction to named execs, who translate those goals into actions for their organizations, that middle managers direct their teams to achieve. Then middle managers report success/failure to named execs, who report back to the CEO who (in conjunction with the other named execs) reports success/failure to shareholders & the board along with financial results.
The execs all are basically on the hook for the results of the decisions made by those below them, but they only decide the broad strokes of the actions of the business.
LLMs could do most of that. The only problem is they can't really make decisions properly. But they could pretty easily turn what is said by the board & shareholders into goals for others to enact - and maybe determine if actions taken by the business support the goals to some degree.
That is like 80% of the job of a CEO.
My wife is on the ace spectrum. She enjoys sex, but only experiences reactive sexual desire (i.e. she'll get in the mood once sex is basically already happening). Effectively she does not experience sexual desire in the way people typically mean that.
That's been a struggle for us. We don't do scheduled sex, but it's something we've considered. Even though we have very good (if infrequent) sex, the frequency isn't the thing that's hard for me to deal with. The hardest thing is not feeling desired in ways I am used to in relationships. That has made me feel insecure and just overall is not great. But it's something we've had to work through.
So all that goes to say: yes, if you find the right person you'll be able to make it work. The key, in my opinion, is talking about it and being very clear about how you're wired and that it isn't anything wrong with them.