SpaceX CEO Elon Musk admitted that his dream of a self-sustaining Mars colony will need vast resources to survive.