https://www.kenrockwell.com/tech/film-resolution.htm#:~:text....
A better benchmark is MTF50, at which you can get about 50 line pairs at ISO 100-50 which corresponds to about 10 megapixels. If we want to be nice we might go as low as MTF20 where you'll get about 18 megapixels of low contrast. I'm looking at Velvia 50, the same film as Ken (https://www.ishootfujifilm.com/uploads/VELVIA%2050%20Data%20...)
Ken also makes the point that the Bayer sensor reduces the resolution - and it does - but he forgets that film has different MTFs for different wavelengths, sometimes even as bad as half for red compared to green.
And yes, you can use medium or large format film, but that comes with very serious drawbacks, and for low ISO film is literally impossible without a tripod, in which case you might be better served with sensor shift instead.