That's the crux of the matter, IMO. But the next level down is to ask whether he's a great CEO at accomplishing his goals, which might be different from those of most shareholders. I think he cares more about the tech than about per share value, something that many on wall street can't wrap their heads around because someone who doesn't put personal net worth above all else is an enigma to them.
F.ex. Wall Street makes a huge deal of how he keeps missing his (self-imposed) dealines. But Elon probably knows that the crazy deadlines makes things move much faster than if he had given more realistic targets to his people, so the net result is worth it to him since he's got basically multi-decade ambition, so the pace is very important if he wants to get to his goals (EVs everywhere, space-faring civilization, ubiquitous clean energy generation, safe AI, whatever).