No idea of the origen of the thing, but before I heard "Sister Rose" I had heard an even grimmer version, in two slight variations:
   
       dada, dada, da, da,
       Your Sonnnn is Deeeaad...

and, to "Camptown Races":

      Your son was killed in Vietnam,
      Doo da, Doo da,...