OK, I am clueless when it comes to digital cameras

My last one I bought was the Sony DSC H-9.
http://www.dpreview.com/reviews/sonyh9/
Bought it when it hit the market a few years back, and it was considered to be pretty good.
Takes decent videos, lets you play with camera settings, but I shoot it in automode, as I am not really up on changing the settings.
It too has a 3" LCD screen that can tilt up which is very useful.
I do know that is it not a DSLR, and I am not really sure what that is.
I said I did not know much about these.
I want better pics from my camera, would this new S95 be a good camera to get?
Can you shoot in automode and expect good pics?
I am going to be reading a few of the reviews on it now.
Would this Cannon be a much better upgrade being only 10. megapixel verses the 8.1 of my H-9?