In my opinion, around that time he stopped being interested in tech and manufacturing of said tech as his top concerns (WHICH HE WAS GOOD AT), and started being more concerned with twitter culture war bullshit. This happened to a lot of people on both sides of the aisle around that time due to the lockdowns, but the lockdowns are well behind us and he's still not focused around "get to mars" or "redefine human energy usage" as his top goals IMO. He's buying twitter, doing what he did at DOGE and repackaging a failed AI company into an IPO on SpaceX's coattails. The stories out of the SpaceX launch business are all about how they effectively "manage up" to get him out of the way and on with their jobs.
I understand the sentiment, and getting as involved into politics as he did was probably a mistake, simply because he is not good at it.
If I may offer a different perspective as to the on-mission part: he realised some years ago that leftism was a grave danger to his plan to make mankind multi-planetary, so he decided he had to get involved, if he wanted to or not. You will probably not agree with this point of view, but perhaps it will help soften the image of him in your own mind.
Yeah, that's just saying "social media addiction" in more words. Also, Star Trek?