The ballet superstar Natalia Osipova shines in the final act of the Royal Ballet's revival of Kenneth MacMillan's work but the rest of it is largely a bland affair