The only way that such an attack would wake them up is if it took the lives of a significant number of them or their friends and families. Most of Congress now operates on a "What's in it for me?" basis rather than per the Constitution.
In Bush's shoes, I'd veto this legislation, make a prime time speech announcing why he was vetoing it, and dare Congress to override his veto. If the veto was overriden, he should challenge the legislation for its interference with his constitutional duty to defend the country against enemies, both foreign and domestic, and simultaneously announce that pending appeal all interrogations of terrorists would be conducted by our 'allies' in Jordan, Egypt and the new Iraqi and Afghanistan governments.
Well, I think one of our chief goals is to get Afghanistan and Iraq to stand on their own, anyhow. At that point what they do with the terrorists they catch will be their own internal affair.
And the Dems paint us as pro-torture. Goodbye 2006.