Could've been a lot worse. The current sentence specifically states TPB because they were already found guilty in another Dutch copyright-infringement case against Brein last year. This is merely a decision to enforce blocking of the 'illegal' site. Also, as it's in a low court with a single judge, and appeal has already been filed, this'll probably go on for years. The good thing to that, is that it'll eventually end up in the European Court of Justice, which earlier already decided (in a case against the Belgian equivalent of Brein, SABAM) that the intrusion of privacy required to block a domain is not outweighed by copyright infringement.
And even if that doesn't happen, Brein still has to get EVERY SINGLE OTHER torrent site convicted, each in their separate trials, and prove every time that the specific site is used for illegal activities, something that in this case cost them a year and a half.
Third and finally: The fine the ISP's are risking is set to 10.000 euros per day, and then limited to a maximum of 250.000. If all else fails, I'm pretty sure the Dutch'll just pay that.
All in all, I'm not that worried, and this is clearly not as big a threat to freedom on the internet as some of the decisions brewing over the Atlantic...