With the politics in the US right now there is zero chance of any type of primarily US-led big science effort. We can't even construct a few billion dollar particle accelerator with out "international cooperation" being in the forefront of the consideration. ONLY a military effort can fly, as far as primary financing by the US, and I don't see that happening in this case.
Nevertheless, I would encourage private efforts, with private funding, and a repudiation of any international treaties or agreements that prevent such an effort.
I would agree with this assessment. Perhaps except for the zero. Probability seldom reaches the asymptote.
But just as Keynesian Economics ruled politics for many decades, the anti-science attitudes of today may slowly erode as science does its slow and steady work to solve problems which will not yield to political pressure.
Glacially, perhaps, the realization that we need a larger presence in space may penetrate even the brie and croissant crowd in Washington.
In reluctant recognition that the sun may have something to do with their indisputable Global Warming, they may allow activities intended to ameliorate the effect. It is, after all, hard to blame global warming on Mars on those ubiquitous SUVs here.