A US Marine who appeared in a video singing about killing Iraqis has apologised, saying he wrote the song as a "joke".