I think we'll find the root means "small," the piccolo being a very small and high-pitched (read: "shrill") flute-like wind instrument

Recall that the prefix pico- means a very small part of something (one out of ten-to-the-ninth; a thousandth of a millionth)