The moon will be a good source of water for spacefaring endeavors of the future, due to the large quantities of ice it has at the poles. With 1/6 the gravity of earth and the appropriate infrastructure in place, it will likely be cheaper to get that water off of the surface of the moon than from the Earth. The most promising use here is actually for producing methane fuel from this water. An industrial base of sorts could develop around this.
The other potential industry will be moon tourism. It could become something like the new Mt Everest. Obviously only for the very rich at first.
Once it becomes a real possibility and not some crazy sci-fi project, governments may start competing, so as to not get “left behind”, even if it is not immediately profitable.
One way or another, unless we destroy ourselves, it will happen eventually. There’s a percentage of people who are just absurdly curious and adventurous, and want to go where no one has gone before, even if the cost is immense. Hell, for some, I’m sure even just desire to get away from their situation on Earth will be a big part of why they go for it. People like this will build the first settlements and bases on the moon and elsewhere in the solar system.
Edit: sorry for the constant edits. It’s a bad habit — I don’t always get my thoughts out on the first try.