I guess living in Japan, where the song has yet to become even remotely popular or well-known, the only time I hear the song is the once-in-a-while when I look it up on youtube... So no I'm not really tired of it. I didn't really like it THAT much to begin with, I think it is a funny song but more than that I am infatuated with the kind of social and technical mechanisms that makes it possible for something to be viewed by many hundreds of millions of people in a very short time. This could not have happened just a few years or decades ago.
Kind of feel for Psy though, but even if he in the end only becomes known for one song he is still right now one of the most recognisable people on this planet. I like him though, he seems like just a nice guy happy to be where he is.