People who are saying that is not possible and that it does not make sense economically speaking have won. We are now in hands of managers, not dreamers.
Hotels on earth aren't exactly money spinners and apart from the zero gravity and looking at the earth the novelty of being in space would probably wear off after a day or two. Projects like Virgin Galactic - for a 'near space' fun ride will probably be more lucrative in the short term. Getting (government funded) astronauts and satellites into orbit is where the money is right now.
Falcon 9 flight to LEO costs $200K in fuel but can lift 22,800Kg. If a person and their seat could be squeezed into 200Kg that's only $2K per person. I think the biggest cost is that the forces and extremes of temperature mean the 'rocket' needs to be engineered and maintained very well as any small failure is likely to be catastrophic - its very hard to abandon ship or divert to the the nearest airport.
If SpaceX's Starship plans come to fruition, the $/kg to orbit cost will fall dramatically.
Ultimately, even if we massively increased the rate of rockets being launched, the greenhouse gas impact would be pretty minimal compared to cars, electricity, and cement production.
The economic issues are more about how space flight has been funded than the underlying physics. The space shuttle for example had some terrible tradeoffs relating to which orbits it could achieve and needing to return cargo etc. SpaceX has dramatically lowered the cost to orbit, but they don’t have the funds to explore dramatically different designs.
"I could get used to a view like this" - Flynn Ryder
It is more about the resources, do we have enough of it to make it possible for regular people to travel to space ? Probably not on earth, so let's build mega factories on the Moon. You might argue it's not possible or feasible for some physic reasons, so let's find a solution. But not money, money does not exist, it's made up.
The purpose of humanity as I see it is not to go smoothly and safely, to be able to go without troubles to a final destination (that does not exist). I say buckle up and let's do it! As Billy said you need to be solution oriented.
Engineering is innovation and maintenance. Bureaucrats slow good change while pushing to cut corners.