Kenneth MacMillan brought psychological depth and sexual passion to the classical repertoire with his first three-act ballet. Not that you'd know it