A better spin on this question is probably along the lines of:

Does SpaceX still need Elon? As a figure head, maybe. As a leader? More complicated, there's probably still some risky path-finding left but the biggest moon-shots are now out of the way and as long as it doesn't become a quarterly returns focused company anyone slightly bullish could probably do a good enough job.

Does SpaceX still need Elon - compared to what - for what?

Does SpaceX still need Elon to control ownership of the company as opposed to selling to "average" investors in order to colonize mars? Almost certainly.

Does SpaceX still need Elon as the CEO as opposed to the "average" other CEO they could hire, to profitably launch satellites into space? Almost certainly not.

At least we reach theoretically answerable questions with this sort of construction, but I don't think we have enough information to answer any but the most obvious versions such as those above.

SpaceX's biggest moonshots, if they keep succeeding and Elon keeps leading, are yet to come.

SpaceX has accomplished only a few percent of their stated mission: "SpaceX designs, manufactures and launches advanced rockets and spacecraft. The company was founded in 2002 to revolutionize space technology, with the ultimate goal of enabling people to live on other planets"

There's still so much work to do.

> but the biggest moon-shots are now out of the way

You'd think so, but if Elon is correct in his words, some bigger moon-shots are still comping. BFR program could be interesting.

Musk owns 60+% of SpaceX, and it is private so quarterly returns are irrelevant.