I am sure that's true, but the problem is that the costs of space exploration haven't gone down the way that e.g. the costs of air travel have gone down over the same period. That, combined with the fact that none of the expected advantages of manufacturing and research in space have panned out means that it turns out there's not much for people on a Moon base to usefully do and it's a lot more expensive than expected for them to do it.

If SpaceX actually does manage to crack efficient rocket re-useability that will certainly help with the cost side of things. The potential there is really exciting, but since there are plenty of uninhabited bare rocks on Earth for people to establish colonies on if they want to, it's still hard to see why they'd choose to do so on the Moon.