The Sun is not a big enough star to ever go nova. Neither are any of our close neighbors. We’re pretty safe from that kind of disaster.
Earth is just gonna slowly cook to a cinder and probably get swallowed when the Sun starts expanding in a couple billion years.