Mike Leigh's operatic debut is meticulously directed and performed, says Rupert Christiansen, who nevertheless has reservations