No, it won't. When the sun becomes a red giant, one of two things will happen - the sun will engulf the planet in it's flaming nuclear maw, or the Earth will suddenly have an orbit much closer to the sun, turning the surface into a baked nuclear hellhole (like Mercury, but...redder).
And there's a giant plume of antimatter coming out of the core. It's not like it's explosive - you need to have equal amounts of the stuff. They react, and throw off radiation and energy. But you need equal amounts of it. There's more antimatter than matter in the vacuum of the core, apparently...
And LOAF was saying that the Paradigm was Confed's newest destroyer at the time of Privateer, not in general.