Will the sun go supernova in the future?

Well honey, statistically speaking, the sun will not go supernova. Our little star doesn't have what it takes to become an explosive drama queen like that. It'll just eventually cool down and turn into a white dwarf, so don't hold your breath for any Hollywood-worthy explosions happening up there anytime soon.