Don't know about him, but to me? It's not that important. I have been following the company since before Musk was CEO.
Musk's leadership, with his particular set of talents, was absolutely necessary during certain crucial periods -- when Eberhard was insisting on decisions with the Roadster which made it unprofitable, for example. Later on, there was no obvious successor.
Now Jerome Guillen is the obvious successor (which led me to breathe a huge sigh of relief when he was appointed President of Automotive).
Musk needs his *health*. He's already stated outright that he wants out of the job of being CEO of Tesla as a public company! Twice! Once in the NYT interview; once when he tried to take the company private.
At some subconscious level, is he *trying* to get thrown out as CEO? Perhaps. The current situation is awful for his health and some part of him knows that.