He had two kinds of supporters. The people like me who respected him because of the things he accomplished, and the ones that love him because he pisses liberals off. He's lost the former but the latter love him even more now.
That's likely true, but I wonder about the distribution. Annecdata, but among my contacts, opinions about Tesla follows feelings about Musk, ie. it'll have really economic impact.
I was (vaguely) in the former category until I saw his petty vengeance on people who he perceived to have wronged him. Eg. he had a Tesla event and arrived 2 hours late. Someone complained, and Musk had his Tesla order cancelled! However I only truly saw him for what he is when COVID hit and he laughed it away as a bad cold while people were dying.