They very nearly beat piracy when there was basically only one streaming service, Netflix, and everything was on it.
Music piracy used to be the biggest thing and now no one pirates music anymore since there are one or two streaming services with essentially 100% of all the music available
Make going legit easier than piracy and piracy goes away
But unfortunately for the studios everyone wanted to get their own piece of the streaming revenues and fragmented the market. In a lot of ways it’s still better than the old cable tv system (everything on demand, no or at least fewer ads, higher quality programming) but the sheer amount of services someone needs in order to be able to watch everything (and even then it’s not 100%) is really turning people off.
If they’d all stick with Netflix or whatever and every studio got on board there’d be basically no piracy now
Just remember how badly it went when Troi was in charge of the enterprise… she crashed it into a planet