Yeah, sadly I don't think this is a priority for most of the public, and many who do have an opinion support the "shut down the pirates, whatever it takes" approach.
Take Wyden in particular: he just won reelection two weeks ago, 57-40%. If this sequence of events had taken place before the election, would he have won by a larger margin? I think it's unlikely. Probably it would've turned out the same, but if anything it's possible he would've done slightly worse, since his opponent could attempt to portray him as a pro-piracy "extremist" who blocked a bipartisan bill that had passed the relevant committee unanimously.
I live in Oregon. Wyden had that election won long before election day. The focus was in the governor's race here and even Wyden's opponent, a Lewis and Clark University law professor named Hoffman, admitted the state Republican party put all its money into the gubernatorial race. The outcome of this bill wouldn't have made a difference one way or the other.
<spam>I think this again shows that groups like the EFF are invaluable. Donate today! </spam>