I did swimming from kindergarten to seventh grade and was very good. I quit because I wanted to focus more on wrestling. I was also very good at that; my sophomore year I would have made it to state had I not torn my MCL exactly one week before the region tournament. I wrestled anyways, and the kid who ended up winning it only beat me by one point when I had a torn ligament.
I had to quit wrestling junior year because of cartilage damage from cross country (which I did from seventh to ninth grade before my knees couldn't take it) and cartilage damage from the MCL tear (it allowed my kneecap to move around more than it should have, which rubbed away some).
I went back to swimming for one final year my senior year, and easily made it back into the top heats for my team.
So to answer your question, yes. You just have to pick your sports wisely (for example, I am 5'11 and 125 pounds, I would get destroyed in any sport like football).
Those were the three I excelled at, I played Little League baseball for a few years and sucked at it (I'm legally blind, it was extremely difficult to tell where the ball was). I did score every time I got on base through a walk or getting hit by a pitch, though!
I did soccer for around five years and I was good, not great. I was good enough to enjoy myself, though, and that's what matters.
_________________
I'm never gonna dance again, Aspie feet have got no rhythm.