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.