I have this problem too - for me it came down to an eyesight quirk. I can’t see perspective above a horizon level with the direction I’m looking in if that makes sense. That is, I can see in perspective below that horizon line but not above. I sucked at netball, tennis, etc. but excelled at hockey where the ball ran along the ground as long as I didn’t look at the ball directly. You can’t hit something if you can’t tell how far away it is or the direction it’s travelling in.

Apparently it’s quite common, and comes from not playing enough hit-the-ball or throw&catch ball games when very young - like, the toddler years. Which was pretty common for female children of my vintage. The brain circuitry that allows perspective vision just doesn’t mature to the point where your brain can interpret perspective. A classic case of use it or lose it. Might be worth getting a really good optometrist to check out your eyesight to see if that’s part of the problem. This isn’t an eyesight health problem apparently, just an inconvenience for usage. Doesn’t affect driving or reading or other activities unless you are madly into duck hunting or the like.

School sport was a major downer for me too, so I was seriously surprised when I had my reflexes measured in my 30s, and discovered that I was in the top 3% of the population for reaction speed. That’s jetfighter pilot level. I should have been good at sport, and wasn’t. Not a big issue nowadays, but growing up it surely was one.