First, this is NOT a CCD, it is a CMOS sensor. Different technologies, different results.
The more pixels you have, the higher the resolution. If you have 10 MPs or 2 MPs on a sensor of the same size, you will get more details, more resolution out of the higher MP sensor.
HOWEVER, resolution is not everything. Color accuracy, noise and dynamic range are sometimes more important.
The smaller the pixels, the lower the dynamic range. For those who don't know, dynamic range means being able to expose both the bright and the dark areas of the image.
So a 2MP camera will have more accurate colors, and will look less washed out than a 10MP image (assuming same technology and same sensor size). But the 10MP image will generally show more details if the scene is not a high contrast one.