Elon Musk decided to be explicitly partisan during one of the most politically divisive periods in American history. Nobody hates him because of his rockets, they hate him because he has taken many, many political and social stances that have nothing to do with his companies.
If you're going to blame anyone, blame Musk for derailing his own companies' missions by taking sides politically as loudly as he has. He's a very poor representative for the things that actually matter.