I agree with other comments that things like his fight with the diver was unhelpful. I don't know what was really behind the threat to take things private. Hopefully he learned something and will focus again on what he does best.
Sometimes, established industry needs someone from outside to threaten do do something even if it isn't the most profitable thing to do. I remember when iphones were charging for ringtones and wallpaper. Google's decision to make an open source OS, and threat to build a phone for it if no one else would, changed the whole game.
I'd rather invest time or money in Musk, despite the risk, just because he built the car, landed the rocket, and I want him to be able to do it again. I can respect an investor who just wants a safe return, but they should invest elsewhere and good riddance. He doesn't need that kind of investor always threatening to pull their money if he doesn't play it safer. Maybe instead of going public, he should start the world's largest Kickstarter.