In real life, Elton John is not only a great songwriter and showman; he is a survivor. But the celebratory final moments of Rocketman can't compensate for the often-dreary narrative that leads up to them