The carbon emissions of Starship already pale in comparison to the reforms we need to pass, but lack the political will to do so.
If rockets became commonplace, they would most like replace leisure travel on airplanes and would eliminate car traffic once you arrive at your destination. The CO2 emission of the current SpaceX rockets is about the same as one full plane across the Atlantic. So if you could take 300 people in one launch, you'd probably take those 300 people away from an airplane flight and it would actually be better for the planet.
https://www.bbc.com/news/science-environment-49349566
And rockets need special start locations to reduce the amount of fuel to reach the desired altitude, additionally the landing places must be way outside of your flight location, so you need extra transportation to your destination too.
Yes, there are environmental benefits to putting the actual destination in space, I hadn’t really considered that.
"i do X high-carbon thing to bring awareness to the plebs"
It seems obvious to me that climate activists can use leverage, like anyone else. In other words it's perfectly reasonable to produce a small amount of carbon in pursuit of making the sweeping changes necessary. Climate change isn't going to be solved by parts of the population choosing to fly a little less often.
That's just a mathematical fact.
The reality of solving climate change is a separate topic. 70% of emissions come from large corporations -- that's where the impact is and always was going to be made.