Why do people use different sized knitting needles?

To increase the number of stitches per inch. That is, smaller needles produce a tighter woven piece, while larger needles produce a looser, more open woven piece.