The level of detail doesn't seem to be too far off from the target video at E3...but the animation isn't even in the same ballpark. It has that typical, choppy "PC" look to it now. The explosions still look nice, but nowhere near the same level of quality as the explosions in the target video.
It also seems to have that same boring presentation that Ubi so loves when it comes to their Tom Clancy titles. Would it hurt them to try and shoot for something a bit more stylish (it doesn't have to be unrealistic or over the top either).
Still, the size and detail of the locations seems quite impressive to me. That scene with the chopper taking off was particularly awesome.
Unfortunately, I think we'll see the same kind of thing with several other big games when compared to their target videos. For example, even if Killzone manages to present detail on par with that CG trailer, I have a feeling the animation won't even come close. Many of the things that make such trailers so impressive are far and away the most difficult thing to complete. I think it comes down more to the talent of the team rather than the power of the hardware.