"Honestly, probably the realistic view is that it never makes sense to colonize, or even send long-term human presence to, any planet besides Earth."

The sole point is the experience of colonizing other planet. We're not looking to get there for the resources (stop for a second and just think out of the box), we're looking to get there to be able to live there as a species.