This is one of the reasons (he's spoken of) that he's having a decent amount of kids and also doing things like Neuralink.
They are supposed to be going back in 4 years time. That's probably going to be delayed, but still people will probably be back on the Moon before the end of this decade. And this time they are saying they plan to stay.
> Both projects have been financed through relatively undemocratic, non-market means.
So are LHC, ITER, the International Space Station, Project Artemis. The US is unwilling to spend the massive amounts it spent during the Apollo project on space right now, but it still spends a lot of money (NASA's budget is about 22 billion USD a year, and the military space budget is about 14 billion USD – over 36 billion spent on space every year) and has been pretty continuously since Apollo was closed down. It would have achieved more by now if it had been spending that money more efficiently. The advent of SpaceX and other commercial providers is changing that.
There is definitely motivation. Some people want to colonise Mars. Not everybody, but likely enough people to make it happen. Elon Musk wants to make it happen, and while there is no guarantee he'll get his wish, I think he has a decent chance of succeeding.
And establishing a permanent base on the Moon probably falls into a similar category. Moon has certain attractions over Mars – e.g. much more feasible target for space tourism, as a near-Earth testbed for developing technologies that may then be deployed to more distant parts of the solar system.
If the US (or a US-led multinational consortium excluding China) establishes a permanent base on the Moon and on Mars, that would increase the likelihood that China would do it too, in order to prove themselves equal to the US. (In principle other countries might feel the same urge, but China is possibly the only country who feels that urge strongly enough, and has sufficient resources, to actually pull it off; the US policy of excluding China from space ventures also gives China a motivation that does not apply to many other countries with which the US is willing to cooperate.)
Whether there is a "need" – the boundary between "wants" and "needs" is a value judgement. People who want to colonise Mars likely have different values from people like you who don't see it as worthwhile.