It seems doubtful to me that that was his main motivation. Afaict he didn’t express interest in Mars publicly until around the time of his PayPal exit.
That said, it’s true that belief in fantasies can motivate people in powerful ways. All the old cathedrals in Europe are a testament to that.
