The biggest show of the artist’s work for over twenty years derails the view that his highly charged colour-field paintings were a reflection of his moods