There was a rumor that Fujifilm is going to announce a 180 megapixel medium format this year. And many people complained about the resolution being in the realm of the diffraction limit. Which made me think if Canon was actually not joining this megapixel race for that particular reason. They also didn't bother competing with Sony's 60 MP sensors.
In his latest article,
@Richard CR said the diffraction limit wouldn't matter since you're going to have a certain distance from printed photos. But with the same logic, you could say it doesn't matter between just upscaling a photo vs real resolution. Certainly, with some viewing distance and certain print sizes, you wouldn't be able to tell a difference between an upscaled 24 MP photo of the R10 and a 32 MP one from the R7. The main difference lies in the ability to crop the pictures.
Manufacturers have been using that 24MP for so long because it sits almost perfectly in the sweet spot between resolution and diffraction. I'm not an expert on this topic, but from calculations from Gemini, I gather refraction with a 39MP sensor already kicks in at ~f/4, so an image taken at f/8 might actually not look that different from an upscaled 24MP one, in terms of detail. However, this is just theoretical.
Going forward, I think we're slowly reaching physical limits where resolution merely becomes a marketing tool, as we see it with cellphones. We know a 108 megapixel phone picture is nowhere near as detailed as a 24 megapixel camera photo. The only things that make these images look good are advanced algorithms and artificial intelligence.