Sadly it dosn't look like that. It was an artists impression of what could be done, but due to time constrants it never happend.
The are addons like GEX and FEX which offer some truely cracking upgrades. To the textures regardless if its DX10 or DX9.