Most of the time!
It never ceases to amaze me how photographers will splash out on the latest megapixel wonder camera. Point-and-shoots now often boast over 10 megapixels and DSLRs are now up to 22+ mps in full frame sensors. Yet where do all those pictures end up? Why, on a computer screen of course, likely 20″ diagonal in size or less.
Scroll down a while and take a look at the many articles here where I include snaps to illustrate some hardware issue. Chances are that the picture was made with my ancient (5 years old) Olympus 5050Z – a 5 megapixel camera which I use at its lowest quality setting, generating 640 x 480 pixel images – 0.3 megapixels. That’s nice as I can upload them to this journal without any further compression. It probably sells used for well under $100.

Before they got caught up in the pixel race, Nikon’s professional DSLRs offered a relatively low pixel count, preferring to focus on sturdiness and speed of operation. The 3 or 4 mp originals were more than good enough for newspaper work, most of the time, and even then the quality of the original could not possibly be reflected in newsprint reproduction.
So my take on all of this is that the only photographers needing more than 640 x 480 are those making large prints (like me!) and pros working for large format glossy magazines where the difference matters (half a dozen other guys).
Of course, if you were to show up at a modeling session with Linda Evangelista, say, with my little Oly, I do suspect that you might be unceremoniously shown the door, but that’s not to say your pictures would have been any worse than the pro’s had you actually been allowed to take them