1) The ISP's now have content of their own, so they'll gladly try to stop the illegal sharing of content on their network, because there's now a profit incentive to do so.
2) The White House acted as a "broker" in this deal, probably forcing their hand to accept the deals, unless they wanted more regulation for this.
3) The presumption of innocence is gone. You can now be found "guilty" without any court saying so.
On 3, that's why I think the Big Content industry is by far the most dangerous entity not only to online freedoms, but other freedoms as well. They are the ones pushing most of the online censorship regulations, and they are the ones pushing institutions like ICE, Homeland Security and even FBI to consider people guilty first and take down their websites or servers, without due process.
I wouldn't be surprised if 5-10 years from now they'll try to get the Police to check your iPod or phone for any illegal songs when they pull you over for exceeding the speed limit.