I don't personally think it warrants a loss of a job, but if it was intentional then whoever did it had to know there could be repercussions.
If it was a mistake, then it's a pretty stupid one. It's not like there's 100 of these songs to get right, there's only 16 teams in the SEC. If you're going to bother to play intro music, then you should be able to do it right.
In general I think the conference media days are pretty dumb and would be fine if they didn't exist. But if you're going to put forth the effort to put on a show, then you should probably do it correctly.