Sharpness is a quality the image as a whole has when viewed as a whole. This has nothing to do with pixel level detail, which will be largely invisible in even a high quality print viewed at normal sizes.
If I hand you two identically shot 8x10 prints, one from a camera with say 10Mp and one from one with 36Mp you won't be able to tell which print camera from which camera.
Forget pixels and pixel counts.
Probably it would be better to
understand pixels and pixel counts as they relate to how prints look. Generally people agree that greater than about 300 Pixels Per Inch pixel density does not improve {resolution/sharpness/detail} in a printed image, and if we accept that as the "standard", we can draw a few relatively safe conclusions...
A 10 MP image with a 4:5 aspect ratio is 2828x3535 pixels. At 300 PPI that will print out at 9.4x11.8 inches. Hence any print smaller than 9x11 will not appear sharper. But as the size is increased from 10x12 on up the sharpness will decline.
A 36 MP image with a 4:5 aspect ratio is 5373x6716 pixels. At 300 PPI that will print out at 17.8x22.4 inches Hence any print smaller than 17x22 will not appear sharper. But as the size is increased from 18x22 on up the sharpness will decline.
Put those two paragraphs together and it is clear that if 8x10 prints are made, then greater than 10 MP will not produce a sharper image, but for images significantly larger than 8x10, for example 16x20, the larger 36 MP image will be visibly sharper.
How much sharper depends on a number of things though, as of course the scene photographed may not have detail fine enough to make any difference! But assuming it does, and the quality of the entire process is high, at some point between 10 MP and 36 MP the differences will become quite visible in 16x20, or larger, prints.
And, for
uncropped images, that is just about exactly the significant difference between shooting with a D700 (perfect for a bit larger than 8x10 or smaller) and a D800 (perfect for a bit large than 16x20 or smaller). Of course another consideration is that it requires a full frame D700 image to crop it to a 4:5 aspect ratio to get a high enough pixel density for 8x10 prints, while with a D800 there are about 4 each 8x10 prints that can be cropped out of each frame! That may not be significant at all to a studio photographer, but for many other subjects (sports and wildlife, for example) the ability to crop may be very significant.