More megapixels means better photos.
A 200MP sensor should out-resolve a 48MP one by a wide margin — more pixels, more detail, sharper images. It's the logic printed directly on the box, and it's the first number most buyers compare.
Sensor size and processing decide most of it.
Once you account for sensor size, pixel size, and the processing pipeline behind the shot, the megapixel count barely moves the needle. A well-tuned 12MP sensor regularly out-performed a 108MP sensor crammed into a smaller chip, especially indoors and at night.