The once popular royal has seen his reputation shredded by his friendship with the late billionaire and convicted sex offender, amid claims he had sex with plaintiffs