I think he's a prime example of being successful in one area does not make someone an expert in anything else and the major issues of giving someone like that too much influence in other areas. Similar to what we see with Bill Gates - both of them have had way too much influence in the US education, ways that have never had a good outcome. I think both of them, and more, have far too much influence over things they shouldn't and have caused harm because of it.
I think people need to be more critical of their influence - we can talk about how great their charity donations are, but we also need to recognise that those donations often buy influence to their whims and often spoken about to gain clout without action - I mean, Musk openly said he would donate millions in stock to deal with world hunger if someone gave him a costed plan, the WFP gave him that costed plan, and then nothing happened. Why make that offer in the first place other than to look good?
Sure, he's made some of his employees millionaires, but it's well documented he treats many of his employees like shit and his companies have been investigated repeatedly for severe safety concerns. He has pretty normal big business/US libertarian views on hating unions and anything to do with workers' rights, and uses his influence and wealth to attack them.
Musk has been left-wing when it suits him. He is on record having voted for Obama, H Clinton, and Biden, and having previously been vocally pro-dealing with climate change as you mentioned. People criticised him and his influence back then too.
It's also on record that he shifted more right/American libertarian after a conflict where the Biden administration didn't include Tesla in a White House summit on electric cars. He, Trump, and a few others of similar temperament did a whole 'ex-Democrat' marketing as part of pushing for Trump's second term.
It's also pretty well documented that he doesn't treat the women in his life nor his 14 children. I don't think doing well in some of his businesses outweighs that.
With this news, it would be interesting to see how much of any of the decisions of SpaceX on this were by Musk specifically vs corporate boards and how the corporate interests and money follows the shifts in position we've seen.