I read that it metaphorically means "little bald head" ("pebble" or "stone" is the literal meaning). It's also a place name in Louisiana. A friend of mine in Texas had a nephew named Caillou (born before the cartoon was made) and they had Cajun roots of some sort, but that is the only time I've heard it used.
- mirfak