Celine Dion promised her children that she wasn’t ‘going to die’ after being diagnosed with SPS