I don't think He's overrated at all but I'm also under impression that he can be done in single shot. One day drinks too much, has some family issue, underestimates or overestimates something and he is done.
I also wouldn't be surprised if some bravado thing he does results in a tragedy and people are done with him. Unplugging a server at the Twitter datacenter can be useful method to see what can be discarded and he appears to be following similar methods that can end up having much heavier consequences.
Elon is overrated. If Elon disappeared, things would be very similar.