An exhibition at Cork’s Crawford Art Gallery connects important Irish artists to heavyweights of the Surrealist movement, says Mark Ewart