The DMCA predates Napster, Gnutella, and Bittorrent. It did nothing to prevent piracy, which exploded in the years after it was passed. Low-enough cost convenient enough subscription services moved people away.
Is this sarcastic? There is still lots of piracy, and streaming services that made it more convenient to consume content, like Netflix and Spotify did far more to reduce piracy than DMCA did.
And quite a few people have gone to jail, including for creating ways to circumvent DRM, which wasn't illegal before DMCA.
And now the Internet is largely a sterile place where the primary business model is built around advertising, selling "data" to "partners", and exploiting gamblers and addicts, while the companies most "saved" from piracy spend hundreds of millions of dollars every year to make increasingly unwatchable, unlistenable, and/or unplayable crap.
I can imagine worse outcomes, but I can certainly imagine better ones too.