It makes me really sad when I think about it. We needed, and still need, the person Elon Musk was at least pretending to be when he founded SpaceX.
He stylized himself as "founder" of PayPal and Tesla, and "chief engineer" at SpaceX, but he's none of the things and even the specifics of his supposed university degrees seem dubious upon investigation. He has also repeatedly demonstrated a lack of basic practical knowledge in domains he publicly talks about while allegedly having deep technical knowledge from committing entire sections of text books to memory. He knows how to seem like a genius without actually having the hands-on experience to back it up.
He has been widely successful as a hype man and somehow managed to keep things going while continuously ovepromising and underdelivering. But I find it difficult to imagine that resulting in a positive as long as the purposes are ultimately entirely self-centered. He seems to be desparately trying to look "cool" and be admired - even going to the lengths of pretending to be world class at a number of challenging video games by paying people to boost his accounts and by widely exagerating his real participation in competitive e-sports. He's extremely insecure and unable to handle challenges to his qualifications or authority.
I find it plausible that at one point he did have the aspiration to be the man who put the first man on Mars but it wasn't driven by the motives he has claimed (multiplanetary species etc) because that would require acknowledging the global requirements to sustain such a project over the long term. Instead it seems to have been entirely about creating a legacy and a perception of himself. I guess if his desire was to be mentioned in future history text books he has achieved that - but not for landing reusable rocket boosters.