At the very least, Artemis is a functional space launch system with exceptional reliability and predictability despite its insane costs. The wasted billions are an embarrassment, but far less so now that we know a) the thing works, and works pretty darned well and b) it is, for now, the only game in town in its class.

Starship is an interesting project with a lot of ambitious goals, but it is far behind schedule in terms of development and the Raptors are suffering from a lot of issues that Merlins didn't have due to SpaceX's inexperience with cryogenic fuels.

So the question to be asked is: do we want an pricey but reliable and proven solution now, or do we hold out for years in the promise of some intangible futurist idea that will likely take far longer than anticipated to become a viable solution for crewed travel? If your answer is B, then it's fairly obvious you're less interested in the rapid progression of space travel writ large and more interested in ensuring a project you favor wins out.

In a perfect world, SLS would be a rapidly reusable rocket with 5 RS-25s, an inflatable heatshield, F-1 derived liquid boosters, and landing legs. But that's not the world we live in, and something > nothing, in my opinion. And I also find it important to put the price of SLS/Artemis in context to other far more wasteful government projects that produce no surplus economic value for people, like the F-35 program or the B-21 (questionable benefit over existing defense systems). In that context, SLS is almost utilitarian, providing valuable scientific jobs to engineers and scientists, while propelling the way to the Moon for this generation's astronauts and explorers.