If I remember correctly, the long exposure noise will commonly appear at the top or the bottom of the image frame. So, the red "fog" in the middle area of the frame would not be caused by the sensor heating.
Yes, the long exposure/sensor heat noise was pink and in the corners on the CCD cameras I owned (D70/D200).
Light leakage through the viewfinder comes to mind.
New test image from today uploaded, this time with the D800. Lens cap on & viewfinder shutter closed.
70-200mm VR-I, 291 seconds, ISO 6400, F/2.8, VR on, AF on.
Identical pattern, more or less. Same test with the 24-70mm results in a black image.
The source of the red fog is the 70-200mm lens itself, not a light leak or sensor heating noise.
Seems pretty evident this is why Nikon warns against using the lens for long exposures & high ISO.
I contacted Nikon about the issue back in 2008 or so and sent them my test image so they could see the issue clearly.
They basically told me to stop taking pictures with my lens cap on.