I think it would be fair to say they didn't really oppose it though. And are happy to welcome its architects into the fold.

Way too many Democrats went along with the Iraq war, yes. But there was no real connection with 9/11, the Bush administration just used it as an excuse to start another war they wanted to fight anyways. Gore wouldn't have had any reason to start the Iraq war.