To fathom hell or go angelic, just take a pinch of psychedelic. Sir Anthony Caro's colossal sculptural installation on a distant planet in a distant future