I'm wondering what makes you so sure about it and why you are so eager to project your own opinion into "most of us"
My personal opinion is that whole twitter drama is really unimportant, yes, twitter is unimportant. Other kind of advancements: Tesla which sparked EV movement, batteries, spacex - materialized grand visions moving forward the world as whole.
TBH I'm kind of puzzled about negative perception about him - especially when it comes from his countrymen because I think that US really gets a lot of value added thanks to him (I'm not from US so might not "read the room" well enough) - looking objectively his companies brought to US hundred of thousands of jobs and not only this kind where selected few at the top in the SV benefits the most - apart form software/design/services positions in hard, modern, advanced manufacturing appeared as well. And it seems like he is a human like most of us and makes mistakes sometimes.