It literally means "This song will kill me", but in this context you will likely say that sentence when, for instance, you don't like that song or even hate it but it keeps playing all the time on the radio. "will be the death of me" means that something(or someone) either irritates you a lot or is harmful to your well-being. This job will be the death of me.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.