The ‘My Heart Will Go On’ singer tied the know with her late husband in 1994