“Nothing ever came of this because McCartney couldn’t recognise good stuff.” Why Paul McCartney’s dream of making a sci-fi musical film about earth-invading aliens with legendary author Isaac Asimov never got off the launch-pad