This mid-career survey may be pretentious, but the British artist manages to summon something sorcerous and compelling ...