SpaceX's ultimate goal is to enable human life to become multi-planetary, which could lead to increased revenue with the possibility of discovering aliens. They aim to achieve this by developing technology and funding it with profits from their conventional space business and Starlink.