> My personal perspective is that the resources are better used for other purposes, but it's possible that I just haven't encountered some compelling reason yet.

Well, people are often obsessed with rationality, and seek reasons to do something, but there is one reason that works almost for anything: just because. If we want to go forward, we'd better try a lot of things, including those that do not look very promising. We don't know the future, the only way to uncover it is to try. Did you hear about gradient descent? It is an algo for finding local maxima and to do its work it needs to calculate partial derivatives to choose where to go next. In reality doing things and measuring things are sometimes indistinguishable. So society would better try to move in all directions at once.

A lot of people believe that to fly to the Moon is a good idea. Maybe they believe it due to emotional reasons, but it is good enough for me, because it allows to concentrate enough resources to do it.

> the resources are better used for other purposes

It is much better use for $$$ than the war with Iran. I believe that the war have eaten more then Artemis already, and... Voltaire said "perfect is an enemy of good". The Moon maybe not the perfect way to use resources, but it is good at least.