I agree with you that's he's a good hype man. But Tesla doesn't need hype any more; they just need to solidify their lead over the EV market. At some point, hype and headline-grabbing turns from a fundraising asset to a corporate liability.
At a $747B market cap, I'd argue Tesla has definitely crossed that line.
Honestly, if Musk poured himself into a new futurist investment, he'd probably do better than he is doing right now... encumbering America's biggest EV manufacturer with stock leverages for a social media platform he took off the public market and completely tanked the valuation for is not a good look.