Hi,
Personally, I feel the largest need for resolution is the suppression of artefacts.
This image was shot at 3.8 m distance using a 150/4 Sonnar on a 6.8 micron pitch sensor at f/8:

The next was shot with a Sony SAL 70-400/4-5.8 at 150mm still at 3.8 m distance on a 3.8 micron pitch sensor, still at f/8.

The lenses are pretty close regarding MTF, but the smaller pitch sensor makes a larger image, with more detail.
The next pair of images shows the original 6.8 micron pitch image to the left and the 3.8 micron pixel image downscaled using Lanzcos interpolation on the right:
Note that the left image has a criss-cross pattern and the strains seem to be stippled, while the right one is more credible. Seen at distance the left image may look sharper.
Both images have now approximately the same resolution, but the downscaled 3.8 micron image shows a good approximation of real detail while the 6.8 micron image has invented a lot of artificial detail. On full frame 135 this images would correspond to 30 resp. 54 MP. On full frame 645 this would be 50 MP resp. 160 MP.
So it would take something like 50 MP to render an f/8 image correctly on 135 or something like 160 MP on full frame 645. With better lenses we would need even more pixels.
What I have seen is that I still have significant aliasing on my P45+ back at f/11, but it goes away almost completely at f/16. As Airy disk diameter is proportional to aperture, we would need half the pixel size at f/8 for non aliased rendition. That figure would also correspond to 39x4 something like 156 MP. Now, put a really sharp lens like an Otus on that sensor and shoot at f4, something like 620 MP would be needed for unaliased rendition!
Best regards
Erik