What makes the "More Cowbell!" SNL skit funny?

I have seen the skit and I don't think it's very funny. Is there something I am not getting? What about it makes you laugh?