There's way more involved that resolution. Your camera compresses the image to jpeg (mostly). jpeg is a lossy format, which is ajustable. For an example, take one of your images, one with lots of detail, open it in Photoshop or something similar, save it as a jpeg. When given the option set the quality to the lowest number. Now compare the result to the original picture. The resolution is still the same, but the quality isn't.
I'm willing to bet most compact cameras use a fairly low quality compression. Here's an example.
Compare the shots taken with a Sony DSC-W80 7.2MP camera:
http://www.dpreview.com/reviews/sonyw80/page5.asp
with the same shots taken with a Pentax K100D 6MP camera, a camera which is heavily critisized for it's poor quality image conversion:
http://www.dpreview.com/reviews/pentaxk100d/page17.asp
Now, lets cut out the image conversion, something the compact can't do, and shoot in raw with the same Pentax (lower res than the compact, right?):
http://www.dpreview.com/reviews/PentaxK100D/page20.asp
See the difference? Compact cameras have come a long way, but in terms of image quality they're nowhere near DSLRs. Which is why they're cheaper.
If you're still not convinced,
here is a 640x480 image taken with my camera phone, and
here is the same one with a Sony DSC-T100, also at 640x480. This is admittedly at the lower end of the argument, but the same thing apply. Resolution takes you only so far. What the camera does with the image after that is what sets them apart.