At the turn of the century, the tabloid press was untouchable – and women in the public eye faced ceaseless persecution. We are still grappling with the fallout today