I was much the same way--absolutely abysmal at any sort of sport requiring the barest ounce of physical coordination. I semi-randomly ended up in ballet class in my early teens though, and started social dance in college because my friends did. I can't say I was amazing at those either, but not so awful as I was at youth sports, and it's developed into a great way to de-stress.
My proprioception for dance is quite good now (even if I'm still shit at remembering specific steps), and while I can't compare it to others', I'd guess that sticking with it forced my brain to compensate for whatever normal proprioception pathways it lacks by building an alternate one. Neuroplasticity is great!
It's hard to practice social basics when you're older because most of the adult population have mastered them and expect the same of others, but there are _plenty_ of people of any age who aren't any good at dancing and are trying to learn despite.