A smaller opening changes both light and diffraction
Reducing the diameter reduces admitted light and changes the diffracted field. The useful diameter depends on wavelength, numerical aperture and the role of the pinhole in the system. It cannot be selected from a desired image spot size alone.
