According to a new biography, Bill Gates became disillusioned with Elon Musk's efforts to colonize Mars and leave a doomed Earth behind.