Yes ending flagrant abuses is the stated goal of the bill, but the methods it uses toward that end leave lots of unintended consequences which will be very, very damaging. Those in support of the bill either haven't taken the time to understand those consequences or simply don't care.

The conspiracy theory is that the unintended consequences are in fact intended by the MPAA/RIAA. Given their past and present behavior, it's not a stretch.