'Pleasure' seeks to embrace frivolity, contradictions and minor perversities’, curator Julian Goddard tells our writer, Dr Joseph Brennan....