Your explanation of why many people ended up disliking him is at least closer to the truth than the grandparent comment's baffling anticausal take of "people hate him because of what he did to Twitter".
But it seems pretty absurd to charge Elon Musk with under-delivering. Do you not remember what the idea of an electric car meant prior to 2005? Or the possibilities and economics of reusable spacecraft just 5 years ago?