It's a double entendre. Stirring up some sugar in a gourd makes the gourd taste good. Likewise, if a couple wants get some of his sweetnes into her gourd, it helps to roll it all around.
The folks who made up those old folk songs were not known for their refined sensibilities.
