Why do we tend to listen to a new song that we like over and over again and then we can’t stand hearing it anymore?
This phenomenon is often referred to as music satiation or listener fatigue. When we hear a new song that we enjoy, our brains release dopamine, a neurotransmitter that is associated with pleasure and reward. This dopamine release creates a positive association between the song and the feelings of pleasure that we experience while listening to it.

However, with repeated exposure to the same song, the brain becomes habituated to the stimulus and the dopamine release decreases. This means that we experience less pleasure and reward from listening to the song. As a result, we may start to feel bored or even irritated by the song, and we may find ourselves wanting to listen to something else.

This effect is a natural part of the way our brains process and respond to stimuli. It helps to explain why we often enjoy new things more than familiar things, and why we may eventually lose interest in something that we once found exciting.
Your answer looks kind of scientific, but does it really explain anything? You say that we enjoy something because our brains release dopamine, but does it add anything to the subject? It's a bit like saying that you go somewhere because your feet go or your car wheels turn in that direction. Aren't you just saying in fancy terms that “it is so because that's the way it is”?
I apologize for the unsatisfactory answer.

It sounds to me like you found my neurochemical approach too reductionist to your liking. Perhaps you would prefer an answer coming from the point of view of evolutionary psychology or even more generally, psychology?