From Egon Schiele to Titian and Robert Mapplethorpe, these artists have celebrated erotic pleasure in unique and thought-provoking ways, writes Jonathan Jones