Well this would be an issue of yours, but not him.
Since you recognize your tendencies to get turned-off with men who need attention or for anyone who complains, as you said.
Perhaps, maybe you can get counseling?
I'm sure your Husband must feel some coldness from you and likely this will cause other problems in the relationship.
Everyone "ages" and their body changes. You married him when he was no doubt in good physical looks and condition. This appealed to you. NOW, he is experiencing NORMAL physical aches and pains. As a result of his sports life. Normal.
He is probably "complaining" about his aches, because he needs attention, which he is not getting from you. Have you talked to him about it? Perhaps suggest he see a Doctor for his aches and pains... and to get help for it.
What will happen, as the years go by, and IF he needs actual medical or physical help... because he cannot do certain things because of his aches and pains??? Will you be willing to help him, since you are his spouse?
In any relationship, there has to be a middle ground and a person should feel 'safe' in talking about their problems to each other. That is what a marriage is. If you tell him NOT to talk about his physical ailments, what then? Do you want to know about his physical health? Or not? As the years go by, everyone ages and gets old and their looks changes and their needs too. HOW will this fact of life affect you? AND your marriage?
If you don't like men when their "manly-ness" disappears... then how will you cope when he gets older, and does not look like when you married him or dated him years ago?
So, you (1) don't like his complaining and whining and, (2) you don't like when men are not "manly" anymore. So 2 issues.
All people, men or women, all get vulnerable too at times... and need support emotionally from their partners. So how will you come to terms with that? What if it were you, who was having a change in your physical abilities and looks? Would you want a man who only wanted you to look young and supple all the time and to never complain about anything, or to need him?
You chose him as a Husband... and there are always going to be times, when our Spouse is not all that we ideally wish for. So the trick is to see them as human. Because even we women are not always so beautiful or perfect either.
All the best,
Susan