A song of contempt is a mocking song. It makes fun of someone by comparing that person to something else.
In this case, the king of Babylon is compared to a dead man going down to the place of the dead. The song imagines him entering that realm in defeat.