Well Q, you may well be right and the song is indeed about the CSS ship, but I'm not entirely convinced.

I'm told that the song is still sung (all day long!) during Cape Town's carnival celebration.