Aerial resolution is, what you see life - camerashutter is opened, in the film-area you pose your microscope with minimum aperture 1 or higher and you look through to a star-like object. The astronomical people have thick books about the different diffraction rings you see from stars (or light-point-scources), depending on the quality of your calculated and sometimes self produced optical system. With the program Optalix I calculate sometimes optics. All optical programs will show the resolution or MTF-function of your calculated system.
Visual you can see (depending on your health) more as you can detect on high resolution films up to 1000 linepairs/mm. Perhaps this is not correct, when you use high speed holofilms with around 2000 linepairs/ millimeter resolution. Once I have done it. The bad of these holofilms is: they are absolutely clear and react like a lightpipe. They have speeds around 3-6 ISO, but you must load your camera in real darkness.
The next is - you photograph on earth terrestrical things, not stars. You need depth of focus. You need planety of field, no curvature of field as any optics will have (normal have 10xf curvature radius, very well have 40xf). Optical design is, to construct a special "caustic" form, where the ray-beams will get the smallest point. Correct calculated, the smallest point with best resolution is very sensitive in focusing, but changing the caustic form to a kind of hour glass, where the small part is very very long, you can minimize the influence of curvature of field, because in the center of the image your caustic is starting on one of the end, and on the corners of the picture, where normally unsharpness must be through curvature of filed, is just the other end of the caustic. Thats the trick optic design use. When you use this trick, you minimize a little your possible resolution.
To the practical question: Of course it makes sense, to use a better lens for "normal" resolution films. A friend of mine bought the Zeiss ZM 1:2/50mm for his Nikon, using with normal 400 ISO films. He was astonished about the better sharpness now. Of course, never he would reach the optical values of this lens with normal 400 ISO films. But now there is more detail, even in grainy parts. And he has a lens for better films - who will know?