There is a huge explosion and the star blows itself apart in an event called a supernova.
The Sun's lifetime will be relatively mundane and no fantastic explosion is predicted before it fades away in the cosmic wilderness.