The demo had godmode enabled for the TGS only, it's not like the final game is gonna be like that... And yes, there was opposition, in the videos you can see dragons shooting you fireballs (and actually hitting you several times).
And the mission could still fail if you weren't successfully contributing to the campaign, as you can see happen in one of the later interview videos.