Terrific, that will accommodate 5,000 people maybe, good luck to the rest of us. One person required 183 gallons of water per year, so for 5,000 people that's 915,000 gallons at 8.34 pounds per gallon that's 7,631,100 pounds of water per year.

--

The three-stage Saturn V SA-512 vehicle used for Apollo 17 carried the biggest payload into space (bigger even that Musk's Space X Falcon). That payload was 110,000. The Space X Starship supposedly can lift a payload of 150 tons. At that rate it would take 24.5 trips a year just to re-supply the water for 5,000 guests.

--

No, the vast majority of humans will never live on space stations.