He's been reckless and made some huge errors in judgement over the past year, but despite it all I hope he succeeds. I don't think he's a hero or a saint like some people do, but his endeavors are having a very real and tangible positive effect on civilization.
Most chiefly, as bad as the climate change situation looks right now, it would be so much worse without the insane amount of 1) change in the public's and the auto industry's perception of electric cars, and 2) innovation in battery technology (especially applied to solar arrays), which Tesla has accomplished. Seriously. We would have zero chance without those two hills having been crossed.
Character flaws aside, Musk is the only billionaire alive (or even in recent memory) whose business ventures are netting any actual positive effect on society whatsoever. Heck, he might be the only one not having a seriously detrimental effect on society right now. You don't have to like him to acknowledge that.