Nottingham Contemporary takes a richly rewarding descent into the art of the underground: a place for ritual, transformation and storage depots