What have I missed?
Hi Arthur,
Allow me to add a few additional thoughts.
1. Red wavelengths do produce larger diffraction patterns than shorter wavelengths, but they only amount for some 21% of the luminance weighting (green=72%, blue=7%). A more meaningful impact on (luminance) image resolution can be expected when one calculates with something like 555 nanometers. I often calculate with 564nm as a 7%/72%/21% weighted average between blue, green, and red, to allow a slightly larger influence of red (because of foliage and such subjects that are a bit more yellow than 555nm green).
2. The intensity distribution within the Airy pattern is not uniform, but rather peaked at the center (even more than a Gaussian distribution).
3. Due to the Bayer CFA, color is more point sampled than area sampled, which will boost the MTF response (but also cause aliasing). Demosaicing does level the resolution differences between the R/G/B channels, because luminance reconstruction is very good and that resolution is reintroduced in the color interpolation.
4. The optical low-pass filter (OLPF), if present, will add to the diffraction pattern blur. Residual lens aberrations also add blur.
In practice, I do not see much impact until the (564nm) diffraction pattern diameter (first zero of the Airy pattern) exceeds 1.5x the sensel pitch. At that point, enough energy is distributed to neighboring sensels to reduce micro-contrast beyond what is recoverable. That is therefore only destructive for higher spatial frequencies (=lower contrast), lower spatial frequencies will lose contrast but may be recoverable by deconvolution sharpening. Low noise image captures will offer the best restoration opportunities.
Cheers,
Bart