Tate Britain's new show presents a picture of the country as an 'apocalyptic inner-city slag heap'