why more megapixels don't necessarily result in better pictures

An interesting analysis written so that even I can understand it -- here .

The quote from Ansel Adams is worth reading the article.