As the vibrating tuning fork is brought closer to the end of the pipe, it causes the air column in the pipe to resonate. This resonance amplifies the sound waves, leading to an increase in loudness. The air column vibrates at specific frequencies, enhancing the sound produced by the tuning fork.