Almost all tourism, and leisure activities including cycling, sailing, scuba diving, etc. are seeing a material shift in their demographics to older folks, usually retirees.

In the USA the most limited commodity is time, and most adults have little to spare until children are grown college tuitions are paid, and they're either retired or at least have enough seniority to get more vacation time than they did before.

If you travel, the people you meet are older, or ex-military, police or fire, or teachers, all of which have more time off and/or can retire relatively young.

To tho OP, try not to hold out for longer tours when retired. Instead talk to the wife and see if you can open up some time for short trips of a few days to a week or so now. It doesn't have to a regular thing, and hopefully things can be worked out so she gets equal consideration for what she wants.

Or consider family vacations someplace where everybody can be happy, you do day rides in the area, dividing time so the family is together but nobody loses anything. I scuba dive, and meet plenty of younger divers who bring the family to an all-inclusive resort in Cozumel. Some of these resorts offer very nice child care and activities so both parents can dive together.

Likewise, from the beginning the Cozumel triathlon was popular with many doing it as their only event because they could combine it with a family vacation and everybody was happy.

My point --- don't wait find ways that you can tour and the entire family can be happy at the same time. Also, though your children are probably too young now, father and child bike trips can be an amazing bonding and growth experience.