Higher frequency sound waves are indeed associated with narrower wavelengths, but the concept of "size" in relation to sound waves is more complex. The discussion highlights that while sound waves can propagate indefinitely, their spatial characteristics are defined by wavelength rather than physical size. The tightness of a sound beam is influenced by diffraction and the aperture of the source, meaning a larger source is needed for a narrower beam. The small size of a needle hydrophone is not directly linked to the frequency but rather to its design for detecting ultrasound waves effectively. Understanding these principles is crucial for projects involving ultrasound measurements in water.