On one hand he's still rich enough to drive 5 golden Tesla's tied together and when they run out of juice call 5 golden helicopters tied together to come pick him up.
On the other, its definitely been a PR nightmare for him and I think a significant amount of trust has been lost in his magic touch, which money can't buy back. Tesla stock can be seen as faith in Elon himself, and its been on a downward trend since this Twitter stuff started. Alltime high of 407 in November 2021. 328 by the time the sale went through in April 2022... 175 right now.
I'm hopeful if it crashes into the ground we get EV's that don't suck ass and are cheap enough to compete with dino juice cars. My cynical ass is of the opinion that Tesla falling apart will just mean EV's as a whole will fall apart, as they're practically synonymous.