SpaceX Starship could well get us there. If they get it working at scale, it'll reduce launch cost to LEO to about $30/kg, and give the world thousands of times as much annual launch capacity.

That makes it feasible to build a lunar colony at reasonable cost, and makes a trip to the moon cheap enough for upper-middle-class people at least.