> Has an anti-piracy campaign targeting the public in the last 40+ years ever actually worked?

A nasty consideration: if these anti-piracy campaigns did work, the anti-piracy organizations would go out of business because the problem is then solved - this is against their incentives. Instead these organizations' incentive is to put on a big anti-piracy show to make an impression an the customers from the media industry. But this show must not be too successful to reduce piracy, since there are no subsequent contracts if the piracy "problem" disappears.