Yes, the zoom lens is a compromise, since the range goes so far in some examples. For instance using a 28-200mm zoom is a real compromise, as is a 50-300mm. But when kept within reasonable power ranges (2x, 2.5x, 3x), the images are anywhere from good, to outstanding. Remember, too, that the camera adds a factor with the sensor, software, color balance, etc. That's another prime factor. With film, consider the color balance, especially with transparency films, and not as much with C41-processed films. The older zooms, especially those, were developed without the benefit of modern CAD/CAM equipment.
The zooms made today, even by the 3rd party makers (Tamron, Sigma), are superb, and their images are just fine. I use a Nikon 200-500mm f/5.6, and I've gotten some spectacular results on wildlife. I've used it on my F6, and it provided great results, especially at the longer end. While I was "locked in" @ f/5.6, the distance to the subject was a non-issue. I use a Sigma DG 70-200 f/2.8 on my Nikon F5 and F100, and it's never disappointed.
It would be great, if I could have all the Nikon primes from 20mm, to 500mm, but economics is a consideration. All my exposures now get scanned, and judicious use of editing, provide results I couldn't have gotten on traditional film printing and transparency conversion.