Tmax and Delta 100 have 150 lines per millimeter, and it's even way higher for certain specialty films like Adox CMS 20 with 250 lines. Though you probably need a drum scanner to resolve to that level. For general use, a high quality scanner at 22 mp is about enough. Thats with 35mm though. You get much much higher resolution with 120 film and larger
I was comparing color films, but sure, speciality black and white films can approach the resolution of current high resolution color cameras, with the drawback that the lack of stabilization will make these resolutions only achievable with a tripod and of course only for static subjects, in which case pixel shift is probably a better option.
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.
https://jpbuffington.com/?p=167