Two outstanding performances and one glorious duet make Saint-Saëns' opera well worth seeing at Covent Garden