The short answer is yes megapixels do count. In the early days of digital photography, when small point and shoot cameras were 1 megapixel or less, it was critical.
The more megapixels, the better the image. To a point. Also, the the more megapixels, the larger the file size of each photo taken. I have a 2.1 megapixel camera (Kodak) that takes very good pictures and each picture is about 1 Megabyte in size. I also have a Canon 4 megapixel camera that also takes good pictures, and each picture is about 2 Megapixels in size.
A 6 Megapixel camera in unmodified .jpg file format would take pictures about 3 Megabytes each, and the 10 megapixel camera would take pictures about 5 megabytes each.
That is a consideration in choosing the size of the memory card and hard drive space to store the pictures. Plan on buying replacement memory cards, because the cameras always come with memory cards that are too small.
Also the backgrounds of both cameras are fairly important. In the days of film cameras, Canon waa an important player in the market and noted for quality lenses and cameras. Sony until recently has not had a similar background, theirs being mostly electronic. They recently bought the former Minolta camera business mostly for the digital SLR camera line as they already had the point and shoots. Minolta also was a noted player in film cameras and I still have one.
I would go onto the websites of both cameras and download the users manual for each camera and go over some of the features and decide from there. Keep in mind, the photos taken by the 10 megapixel camera will have to be resized if you plan on sending them over the internet (I do on my 4 megapixel camera) as 5 MB pictures just take too long to upload and download, even with high speed internet.