Critics call Celine Dion’s high-stakes comeback the riskiest show in music history, and the singer’s raw, tearful performance proved why