You know there are other ways of travelling distances, other than cars. Why not travel by train, if you book well in advance, and get a senior's (or disability) car they are not expensive. Saves a lot of worry, letting the train take the strain.
I can totally understand anyone not wising to have a dog in their home, perhaps you may need to choose between your pet and your family.
Younger people have to lead such very busy and stressful loves these days. Those with young families, and in busy jobs are often working very many more hours than they get paid for. No wonder they cannot find time to host elderly parents and animals.
I have five AC, one lives nearby so I see her once a week, when she comes straight from work to have her evening meal with me and a chat. She stays less than two hours. Another I have a weekly gossip with on the phone most weekends. The others I tend to have a quick phone call with every two or three months,
For Mothers Day and my birthday I always tell them NOT to send anything other than a card, but to use any monies they would have sent present with for a visit to me sometime in the summer. So, this way usually see them at least once a year for a couple of days.
Those that have a spare bedroom, I try to get to (by train), once or twice a year, I love them all dearly, hope they have reciprocal feelings for me. But, know that there main emphasis must be on their own families. I have done my bit, bringing them up, sending them out into the world with careers, etc. I would actually be rather concerned if any of them felt that they needed to concentrate on me.