more sci-fi should deal with the fact that your average Enterprise starship has a fuel tank measured in Chicxulubs of antimatter
even if it blows up in orbit, that's still 90 teratons of TNT going off. That's equivalent to a solar flare.
You're still going to Have A Bad Day.
which makes me wonder about the fact that anyone lets these starships orbit their planets, let alone sometimes they manage to land.
Earth keeping their shipyards at Mars is a good start, I'd think if I was in charge of biosphere protection, I'd be more like "yeah ya'll can park at Jupiter, and take some chemical rockets down to Earth"