The Israeli choreographer's first ever work for the Royal Ballet goes down a storm but is some way below his best, says Mark Monahan