I thought it was just as funny when I was younger. I specifically remember, more than anything else from Sid the Science Kid, having the episode the song is from recorded onto our DVR, and rewinding it over and over again. I think my mom found the song amusing, too.
Honestly, I'm just waiting for the day it becomes a big meme. I mean, STSK is already a popular show in the meme community, and that food song has tons of meme potential.