It will pass in the Senate, but fail in the House. As a result, the administration will still launch "targeted air strikes". This will be devastating to the limitation on war powers, but the divided Congress will fail to take action against the executive branch. As a result, war powers will remain within the executive branch and without Congressional approval, even after Obama leaves office.
This could also easily start a major regional war, as Syria would likely have no choice but to target U.S. allies in the region, instead of the U.S. itself. Iran, Egypt, and Russia all have mutual defense agreements, which could start a major, major problem over there.
What happened to this Obama guy? At some point, even conservatives had some faith in his foreign policy. He ran on an anti-war foreign policy for God sakes. Clearly he's not at the wheel.