What is the ultimate fate regarding supernovae or black holes for the Sun?

Answer

It lacks the necessary mass for those spectacular deaths

The death of a star is critically dependent on its initial mass. Spectacular end states such as a supernova explosion or collapse into a black hole require the star to possess significantly more mass, typically estimated to be at least 8 to 10 times the mass of the Sun. Since the Sun falls far short of this threshold, it is incapable of undergoing the core collapse necessary for these violent events. Instead, its death involves gentler processes, culminating in the shedding of outer layers and the eventual formation of a dense, cooling stellar remnant.

What is the ultimate fate regarding supernovae or black holes for the Sun?
sunastronomylifespannuclear fusion