Asshole or not asshole, the role of a CEO of a public company is to sign off quality of life for the public.
Musk is not signing off anything. At best you could say that he's aspirationally signing off quality of life for people who are not even alive yet and would benefit from a less warm Earth. But that is contentious given that solving transportation alone won't solve climate change and Tesla for sure won't be the sole player in transportation. As a matter of fact it will be a small player and the electrification will be provided by the legacy OEM.
Character flaws pale compared to the big question: "What is this guy doing for me?" . There were no such questions with the other people you mentioned.