That's quite a merry song.

Despite not being able to understand the Germans' lyrics, I feel like "beer" was mentioned many times.

That's right.

The song is "There's no beer in heaven so let's drink while we can~".

Hoh, hoh? quite straight forward