If you google "Scotland's Burning song history" there's a couple of tales from the American Civil War which might explain its place in US memories. It also features in umpteen collections of children's songs, apparently, so it wouldn't need to be an oral tradition.