Square-Enix' Next-Gen engine, or how they think it's gonna look on Next-Gen consoles (runs in Realtime, on high-end PC):
Take that footage, apply 720p with nice huge-ass jaggies, 30 fps (moar like ~24 fps), lots of blur and capped visibility, and you might get something like that on NextGen consoles. That is, if everything is well optimized and the hardware maxed-out. And as we all know by know, you won't get that earlier than ~3-4 years into the console life cycle.