The artist's immersive show at Manchester's Aviva Studios unfolds with scenes that are alternately majestic and crass
