That’s not quite right. Our sun has never gone nova, and is a fairly young main sequence star. It’s still in the first “main sequence” of fusion after accumulating from scattered matter. It’s heavy enough to do fusion, but not heavy enough to really “properly” go boom at the end.

While novas form heavy elements, the originating star either becomes a neutron star or black hole. Sol, our sun, is a a “normal” star which means it won’t properly go nova. It’ll just “burn out” and become a white dwarf.

The matter ejected by a Nova flies out into the universe and falls in the gravity wells of other Solar systems. So our heavy elements likely hail from millions of other past stars.