Diffraction causes a point source to be imaged as a blurred spot at the lens focal plane. The angular extent of the blurred spot depends (inversely) on the diameter of the lens aperture, independent of focal length. This is generally what astronomers care about. Photographers usually care more about the physical size of the diffraction spot at the focal plane, which is the angular extent multiplied by the lens focal length. This quantity is proportional to the lens f/number.
Consider taking a photograph of a resolution target with two lenses of different focal length, then printing the images so that the resolution target is the same size in each print. How blurry will the resolution target appear? If I (photographer) am allowed to move closer to the target with the wider lens, so that the target has the same size on the camera sensor, then final blur depends only on f/number. If I (astronomer) am constrained to leave the target at a fixed distance from the camera, so that the longer lens produces a magnified image of the target on the camera sensor, then final blur depends only on lens diameter.