I tend to think it's a waste of money, unless the plan is to move everyone there once we're done destroying this planet.
Robots could do pretty much anything a human being can do, with more R&D, and improving robot capabilities would cost a small fraction of putting human beings on Mars. (The moon? I heard it's hollow and the aliens living there told us to stay away.)

Succeed in what fashion? I think it would bestow minerals, mining, and information if we gave it enough time but humans (IMO) do not have that time. I would concentrate on Earth, except for rovers or telescopes, and build better structures which might survive storms or submerging. Actually, I like underground homes as an idea.

Honestly, I don't care if it does.
We have no business being anywhere else but here.
We've managed to set this rock on an unsustainable course. We have no right to do that anywhere else.