Peter Murray says the Renaissance artist’s sensual, uninhibited depictions of male and female beauty made his reputation and reflected his sexual zeal