And we need a transportation that is much more economical than rockets, otherwise it will always be very costly to lift a kilogram into space.
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.