Un pignouf is a ill-mannered, coarse / rude person. It's usually translated by "peasant"

If you want traditional French songs, you'll want to google "thierry klein" (lyrics, midis, sheet music), "rassat" (lyrics, midis, sheet music), "medietrad" (only lyrics), Mama Lisa's World France page -kids songs- (lyrics, midis, mp3, sheet music and English translations)