MissAdventure
Are you up to something? 
Are the lyrics funny?
You do make me smile.
Yes, the lyrics are funny, I was surprised, because Auf der Vogelwiese means On the bird meadow, so I thought - assumed
that this was going to be some sort of homeland song about birds in the country air, that sort of thing.
However
it appears that in the bird meadow an event was being held and there was a beer tent, and someone named Franz drank lots of beer. The somg relates that in the morning he was fit and well, but later, as the singing ends, he was "unter Tisch" - under (the) table!

LINK > musikguru.de/ernst-mosch/songtext-auf-der-vogelwiese-474787.html
Auf die Vogelwiese ging der Franz,
Weil er gern einen hebt,
Und bei Blasmusik und Tanz,
Hat er so viel erlebt.
Das Bier im Zelt war gut und herrlich kühl,
Darum trank der Franz viel zu viel,
Früh am Tag war er so frisch,
Doch Abends lag er unterm Tisch.
Das Bier im Zelt war gut und herrlich kühl,
Darum trank der Franz viel zu viel,
Früh am Tag war er so frisch,
Doch Abends lag er unterm Tisch.
Google translate gives the following.
Franz went to the Vogelwiese,
Because he likes to raise one
And with brass band music and dancing,
Has he experienced so much?
The beer in the tent was good and wonderfully cool,
That's why Franz drank far too much
Early in the day he was so fresh
But in the evening he lay under the table.
The beer in the tent was good and wonderfully cool,
That's why Franz drank far too much
Early in the day he was so fresh
But in the evening he lay under the table.