Obviously there is a place for "little" guys in soccer. That said, EVERY team needs a certain "physical presence," no matter the raw size of it. All things equal (and they seldom are), I'll take the bigger kid every time.
The higher you climb on the competitive ladder, the more technically proficient (and or physically tough) the smaller player must be to thrive.