Who is little Jimmy?
Adding "little" in front just stresses the fact that we are talking about a kid, so the references are about dumbing it down for kids.
Johnny is probably a bit more common than Jimmy, but I've seen both. See e.g. [1]
It just sort of means any below-average person.