Magnetic fluctuations in the classical XY model: The origin of an exponential tail in a complex system