My dcs are older teens now.
Football seems to have been THE go to for boys in primary. But neither of my dcs ever played in a team etc… and it has never stopped them from joining in. I think the reason is simple. Not all boys play in a team. More or less all know the rules and that’s plenty to be able to play at recess tbh.
Some of the boys didn’t like football right form the word go. And that was ok too.
fwiw as soon as they hit secondary, all that football malarkey disappears. It’s really nit the end and be all iyswim.
I really wouldn’t feel guilty about not taking him to football. I didn’t do it with mines because I refused to stand on the side lines every Saturday in the rain/cold etc…. They did well Wo it. And it didn’t stop them making friends.