My DS has never enjoyed football but used to play at lunch times with a small group of friends at primary school. He feels more self conscious at secondary school because he says his primary friend's knew and didn't mind that he wasn't very good at it but there's more pressure at high school. The boys that are good at football seem to be the popular ones.
He's quite reasonable at most other sports - rounders, cricket, running, badminton and tennis but doesn't like football or rugby.
He does other sports in school clubs and outside of school.
He's now found a group of friends that are all into other stuff and they do (what my Dd thinks are) nerdy/geeky things together like chess club, coding, rubix cubes, table tennis etc at lunch times.