Another scenario to think about here is how does he spend any amount of quality time focusing on SpaceX or SpaceX projects when he’s running day-to-day ops at Twitter for sure and supposedly Tesla too. Something has to give.
If he’s mostly spending his time on Twitter I don’t see how it’s all that implausible that for SpaceX he does randomly show up and toss around ideas and people tell him yes so he goes away and they can go back to their normal ops. I don’t know either way, but I wouldn’t really dismiss it so offhandedly.
However, he did found SpaceX 20 years ago in 2002. And their first successful launch was in 2008, 14 years ago.
It's entirely likely he puts less effort and impact into the daily running of SpaceX now, however I don't believe his last 6 months running Twitter invalidate his last 20 years running SpaceX.
Have to imagine investors in Tesla are not happy right now with such divisive activities from Elon Musk in the public sphere and the lack of focus on the company (yes I can say factually he is not focusing enough on Tesla).