My 10yo did rugby for a year, athletics for a year, tried judo and aikido. Stopped them all.
He loves swimming, but is skinny and finds changing too cold in winter (can't say I blame him) plus with long hair it's horrible getting home and you can't use a hairdryer at the pool due to covid (not sure the men's has sockets in the changing room, plus teasing...). But, he'll continue with classes after Easter in time for summer and going to the beach (we're in a hot country). Just once a week after school.
He loves his bike and skateboard, although he hasn't quite got the hang of it. And he loves running around the park with mates, beach with the dog, and hiking with the dog - partly cos he likes finding sticks shaped like guns, sitting on a tree stump to eat his packed lunch and wild peeing 
So he gets plenty of exercise.
He hates football, always has. Has an interest in basketball, but doesn't want to practise
he's not a fan of ball games, tbh. He did love athletics, but since they've gone back after lockdown, there are no competitions for his age group so his motivation has gone. Yes, still 2 years later.
He's just tried sailing with school and loved it, so again we can try with this after Easter, or perhaps a summer club.
He bloody loves horses (and donkeys!) but that's waaaaaaay out of our price range. Again, maybe a summer thing for a month.
He's on the waiting list to go to scouts in September.
At age 5 your ds has got plenty of time to try new things.