It's a common misconception that diffraction limit depends on pixel pitch. It doesn't. It just depends on image format, lens quality, and on your personal idea of sharpness. Formulas that compute the aperture where an Airy disk's diameter will equal the pixel pitch are amusing but irrelevant.
The "diffraction limit" does of course not depend on pixel pitch, since there is no "diffraction limit" - thus it can't be limited ..
But there is a resolution limit and image degradation caused by diffraction .
And there is a point of sensor resolution against F-Stop, where additional megapixels do not add more information and are simply redundant information filling up your memory card or harddisk space. Of course this as well is not a hard limit, but a continuous process.
Is it sufficient to have 1 pixel at the size of an Airy disk? 2x2 pixels, 3x3, 4x4 ...
I think it is safe to agree, that at some point no relevant information is added.
Usually it is said, that the eye cannot resolve more information than 1500-3000 points per image diagonal, depending on the detailed circumstances, like contrast, viewing distance, personal eyesight, etc...
For a 24*36 mm sensor/film this would be
SQRT(24^2+36^2) mm /(1500 to 3000)= 14,4 to 28,8 Micron
Since the size of the 1 ring of the Airy disc is about 1.35*F-Stop *1Micron you see at F11 it starts hitting which is the general experience with that format. ("F11 [sometimes it is said F8] and you'll be there..")
This is also the reason, why I try not to use F-Stops much above F 4.0 with my Canon Powershot G11.
What easily can be seen as well is, that very high resolutions, like 34 Megapixels will only add valuable information and allow for bigger enlargements at near viewing distance (like looking at a 2*3 m print from 50 cm) if very exact technique is used (accurate focusing, tripod, MUP, excellent lenses etc ..)
and the aperture is not too small (The F-Number not too high).