SLS isn't more absurd than putting Humans on the Moon in the first place. It's an insane task in the best circumstances.
With China on the geo-strategic horizon, and maybe even with Russia really getting back into the game, I'm pretty sure that NASA or any other Western-based (and US-led) space agency will get funding for an indefinite period of time. Case in point, just show a short video like this [1] to any decision-taker in DC and I can assure you that that funding will get instantly approved:
> The Nudol missile, which Russia will use to shoot down enemy satellites in case of war.
> Flight speed from 2000 to 5000 meters per second. In this video, you can judge the speed yourself.
[1] https://twitter.com/TobiAyodele/status/1563635402967322624
Seems implausible to me. If SLS fails this year, you can forget about the second launch, meant to be a crewed launch, in 2024. And by that time I think Starship will be flying. The absurdity of keeping SLS going will become too great even for Congress to tolerate.