"I was probably very tired that day — very tired," Céline Dion joked of almost passing on the 1998 Oscars winning tune