For TV series/movies it's very different, lots of shows, series and movies are exclusive to one streaming service and lots of shows, series and movies can't be found on any of them.
But still I don't think a majority of potential customers will be enough annoyed by the current content fragmentation to go back to piracy. Also because the piracy tools have become less and because it's still hard to find what you really want, even when using some simple as popcorn time. I just think customers will start to own more than just one subscription and will probably switch from time to time from one subscription to another to get access to the content that is exclusive to one of the streaming services that are available. The loser here is clearly the customer that will pay more for less, but it won't hurt enough to make piracy popular again.
Why has Spotify/Apple Music been able to accomplish this while TV/movie services can't?
I haven't wrapped my head around how this could influence the creators and services enough to work together, though.
Piracy, in many cases, offers a superior product to streaming. If I go to ThePirateBay, I'm virtually guaranteed to find whatever movie I'm looking for, in 1080p (or even 4k nowadays) quality, without any DRM, which can then be easily streamed from Plex or Emby on any of my devices with no regards to regions, often with more options for subtitles and audio tracks (if you're watching anime).
I have Netflix, Hulu, and Amazon Prime, and frankly I already hate having to search all three for a movie, just to find that they don't have it anyway; I already pay enough for these services, I really have no interest in signing up for yet another just to make my search for a movie even longer.
Spotify (and nowadays Apple Music for me) has made it so that I've completely stopped torrenting music, since they offer a superior product to ThePirateBay. It has nearly any song I'm looking for, in decent quality, and there aren't banner ads for "Hot MILFs in my area!" all over the place in a convenient app that works well on my phone. They made the legal option superior, and as a result I don't mind paying the ten bucks a month for it.