I remember the first moon landings in 1969, it was a huge thing,
I would have taken such a mission in a heartbeat in my 20s and 30s.
But age, parenthood etc makes us more risk averse, more aware of our own fragility.
Even if nothing practical comes from such ventures then maybe it stimulates philisophical discussion about our place, our own planet gives an objective view if you like.
I think there is a shift away from ideas of invade and conquer which have influenced our own trajectory as a species and no longer considered virtuous. The Fermi Paradox suggests that other life on exo planets are simply watching - they have moved beyond the need to conquer and destroy.
One aspect that sticks in my throat is the cost. The return to moon project of which Artemis is a part is costing $90 billion dollars. That amount could feed over 100 million hungry people for a year, or build wells, bring education, healthcare and contraception to many people.
18 thousand children a day die from starvation on our planet. Given such a humanitarian problem we need to consider if Artemis is a wise expenditure.