The Elon Musk Company does what Elon Musk wants. Tesla is dying, X is a disaster, so he bundled everything into the one company that had a bright future, SpaceX. There is no grand vision or endgame beyond do as Elon Musk wants. Going to Mars or the Moon or whatever was never a vision or mission, just a story to tell.