As others said, sports a neutral that tends to absorb the attitudes and values around it and sometimes those attitudes are terrible and not everyone can access better than what is in their community. It can't be universally applied, but that doesn't mean it isn't an issue for many children so I don't think it's unreasonable to loathe what it's doing for your DS or others.
On the flip of that, I think one of the value issues is effortless excellence and things in certain areas only being "worthwhile" when we can maintain that facade and this can be reflected both in parents' attitudes towards it and in schools where PE and or similar subjects treated in a same way like vocals in music or many things in art where it's too often 'go do' and kids are often blamed for not being naturally picking things up things that should be broken down far more into skills to bring together. As others have said, the revelation of actually learning these skills as an adult can do wonders, but it's an issue that that's what it takes.
As was said, no one first starting is going to be excellent against people who've had years of experience. I remember my first year in wrestling - my nickname was Miss Worthless (and that was nice for wrestlers), I could have used more breaking down of certain skills, but a good chunk of it was excepting I wasn't going to be good for a while and that I'd always had a disadvantage with those with more experience let alone a biological advantage the guys had.
There are various ways this could be handled that could improve things for more kids, some have already given suggestions for this specific case, but with how much schools and many volunteer organizations are stretched, there isn't an easy solution there on scale. I mean, that it's well-written now that late KS2 and into KS3 kids - particularly girls who have a greater shift in centre of gravity and are more likely to be injured at that age partially because of that - need more skill training, need more things broken down in components to work on before bringing them together, but too often it's "easier" to chuck them all into some game to "go do". That is a values issue too - and it's not valuing our kids and their health.
And lastly, had those kids who hated PE absolutely no responsibility to themselves to just get in with it? Because it smacks of it being everyone else’s fault but their own.
I think, when kids are concerned, we as the adults have the responsibility to ask and find out why. There is little benefit is just telling a child 'you should try harder' or calling an adult 'triggered' for having a complaint.
When I was 12, I was a smart ass in PE and refused to run the warm-up. I walked. I would quote my mother who would say "I'm only running if there is a man behind me with a gun". Eventually, the others were moved on and the boys' PE teacher actually walked with me during my extra assigned laps and we talked about what I had said, we compared scars, my clicky knee, and so on. He was very no bullshit, made me take responsibility for my choices and would tear apart anything that sounded like an excuse, but he also built rapport with me and didn't write me off for not just 'getting in with it' or being 'one of the counselor's kids' (as he wasn't even my teacher, I'm not even sure if he was aware of that - and I didn't care if others won, I was happy to cheer them on, I just didn't see the point in doing it myself when all the effort to be at the top never protected me. It was logical to child me).
He one of very very few teachers I had at that age that helped me feel like my limitations were workable, that they weren't just something that made me a fuck-up they barely put up with while they had to.
It was teachers like him that helped me get into lifting and wrestling. I couldn't have 'taken responsibility' without a teacher like him because child-me didn't have the skills or well-being to do that. You might view it as blaming everyone else, I view it as a developmental issue and a social values issue - he was having to counteract so many other values represented by other adults, peers, and the environment and my developmental limits on seeing beyond my "normal". In some spaces, it's 'only those who win matter' which puts many off. I didn't have that, I didn't think I mattered either way and so put my energy in just what I needed to survive (if that at times). That kinda turned into a strength for me, but I needed guidance to do that. I couldn't have pulled that out of my arse as a child, because I was a bloody child (literally and figuratively).