No, it wouldn't be a drinking song today and it almost certainly didn't make it as a drinking song back then.

Let's just say that as poetry, it trips over its own feet.