There is an important difference between feeling disappointed that your child does not share an interest or enthusiasm that means a lot to you and feeling that your child is a disappointment to you. The first is natural, and probably universal, the second is potentially very damaging.
I have occasionally been disappointed that my dds are so utterly uninterested in pretty dresses and girl things. Sometimes I see other girls in lovely colourful clothes, and feel a twinge that I do not have a child who will provide me with an excuse to buy the clothes that I would like to. But that is my problem, not theirs. I am a bit disappointed that my oldest dd decided to stop playing the flute, because I loved hearing her play, and want the dc to have the chance to share the enjoyment of music with me. But we talked about it, she convinced me that her reasons were valid, so she stopped. My ds is a bright interested boy, but he is not an academic highflyer, so occasionally I am brought up short by how different he is from me and from his sisters, and I have to remind myself to be very careful that I do not inadvertently say anything that might make him think that we think any less of him because he's probably not going to get 11 A*s at GCSE like his big sister did.
None of these are things I could have predicted. On some level it's natural to expect that your child will share many of your own feelings, abilities and interests. And in fairness there is a particular joy in being able to share with your dc something that has meant a lot to you. But there is a different kind of joy in realising that they are their own people, and they may introduce you to things that you never would have thought of yourself and that your job as a parent is not to rear clones of yourself, but to help them to become themselves as best you can.
So your dh needs to work a bit harder on finding things he can share with your ds, rather than resenting him for not being a mini-me. It's great that your ds loves being outside, and it sounds like that might be something that he shares with your dh. Maybe long walks might work for them, or hiking trips or geocaching? Maybe your dh could teach your ds how to build bonfires, or use a telescope, or take him to the zoo? There will be loads of ways your dh can take an interest in your ds and find things they both enjoy, he just needs to work at it a bit.
I think your dh needs to grow up, very fast. You need to spell out to him in words of one syllable that it is natural to be a bit wistful if your child resolutely refuses to share your interests or ambitions, but that it is his job as an adult to find something else that they can bond over. I suspect your dh is feeling a bit left out and rejected by your ds's lack of interest in sports. So rather than just having a go at him, it might be worth pointing out to him just how much little boys need their dads, and that he needs to get over himself and help your ds become the boy that he is, rather than the boy your dh was hoping he might be.