As an amateur, one of the "fun" things about getting a camera like the D800 is that it pushes you to learn more, improve your technique, and exploit its capabilities. I see this a challenge, rather than something to be overly cautious about.
Also, capability does not equal complexity.
My guess is that I can go out and take photos in exactly the same way that I do now with my D700 and most of them will be as good or better. Yes, in lower light situations requiring longer exposures I will be more likely to bring my tripod along. But, there is still the "P" mode, auto ISO, and other settings that should make most photography relatively simple.
I look forward to the challenges this camera will present.