Jeanette Scully died from an ‘extremely rare’ and aggressive cancer