As the Tate Modern stages the first major exhibition of surrealism for 20 years, critic Waldemar Januszczak presents this exploration of its three major themes - sex, desire and eroticism.