If Musk is in fact a lousy boss who’s screwing up his company and its only chance of survival is having Musk wander off to “get hooked on the next thing” and let a competent leader replace him, then where the hell is the long-term advantage to “impressing” Musk or “working closely” with him or “hitching your wagon” to him?
The whole point of an employee throwing their cap over the windmill, so to speak, to go all in on a risky venture with an adventurous boss is that their confidence in the vision and trustworthiness of the boss outweighs their fear of the accompanying risks. This standard trope of inspirational business folklore premises that you hitch your wagon to the boss’s crazy moon-shot idea because you have faith in your boss, and have very good reason to believe that he/she has what it takes to make the dream happen, and also that he/she will be loyal to you in return for your beyond-the-call-of-duty service.
But if you’re confronted with a situation where (a) the business venture is high-stakes and high-risk and also (b) it’s highly likely that your boss is a petulant bastard with no personal loyalty to employees and a disastrous lack of impulse control, then that makes the wagon-hitching choice a much more questionable one.