Pina Bausch's final work is here imbued with a swooning and emotional atmosphere, says Sarah Crompton