A small to average-sized star like our Sun will never experience a "supernova" phase. Supernovae occur in massive stars, typically those with at least eight times the mass of the Sun. When such massive stars exhaust their nuclear fuel, they undergo a catastrophic collapse followed by a dramatic explosion, resulting in a supernova.
Instead, when the Sun reaches the end of its life cycle, it will expand into a red giant and then shed its outer layers, creating a planetary nebula. The core will remain as a white dwarf, which will gradually cool over time. This process is quite different from the explosive fate of massive stars that end their lives in a supernova event.