A photographer who is using good technique today, and know the strengths and weaknesses of his lenses and uses them accordingly (no matter what those lenses are) will be just fine with the D800. Yes it will require top notch technique to make full use of 36MP and to see a noticeable improvement over 12MP (and why else would anybody upgrade to 36MP if not to improve his results).
Nikon published this guide as a precaution against casual users who will shoot this new camera with something like the 24-120/3.5-5.6 lens wide open and hand-held at 1/20s and then look at the image corner at 100% crop at his monitor, and then complain, post threads, return the camera or send it to Nikon service for adjustment.
As for the lens list, these are just examples of lenses that will work well with the D800. And I also detect a bit of marketing here - why not encourage a D800 buyer to also buy some new Nikon lenses? Once the camera is out, this list will be very easy to disprove by shooting some $50 lens (like the Nikon 50mm f/1.8 AI) which at f/8 will without any doubt provide stunning resolution even for 36MP. Or if you want to "splurge" invest in the Nikon 50mm f/1.8G which at $220 will out-resolve this and future even higher MP bodies.