No it isn't.
The only way for someone to think he was some awkward autistic rizz master. Was to be fooled.
At one point it was possible to not be paying attention. Getting distracted by the smoke screen etc. But even the most basic look into him and his history. No one would ever mistake him for someone with charisma or talent.
Unless you consider money charisma. I really can't agree with you or understand where you're coming from. Anyone who's ever known the man as a peer or personally pretty much universally hates him for good reason. Including his Ex-Wives, his father, even his children, and that ghoul Peter Thiel.
People liked the concept of boosted Space travel, Electric vehicles, etc. Musk was smart to invest in them. But he had no contribution of note to any of those companies other than his money. No one ever cared for musk anymore than that. And then once his erol-ness was on full display finally the people who had been fooled had to acknowledge reality.