"Team" needn't mean "sports", Jon. Lego League, band, girl scouts, the church bell-ringers' group...any of those will still require acting as a team in specific circumstances.
Since you brought up sports, though, between my four, we've had a pretty wide range of reaction. Second dd was a major jock, the sort who got watched by college scouts (here is where I insert a long cautionary tale about metaphorically shooting oneself in the foot). Third and eldest both managed to have fun and not embarrass themselves overmuch. Youngest...well...I'll never actually know how she could have done because in her one attempt at gymnastics class I discovered she had a natural talent for allowing other kids to cut in line ahead of her so she never had to actually do the activity. But hey, at least she creatively problem-solved.
