Life seldom allows us to take the exact path we planned.
While I understand the OP's discouragement, I would be looking for ways to compromise and make the most of the situation.
My wife wants to retire to Maui...but almost impossible to own a (large) boat there.
I could probably settle for a trailerable boat to live in paradise
But I am also not too sure my wife will really want to be that for from our boys on the mainland, and if we are blessed with grandkids down the road, all bets are off.
And as someone else mentioned, my wife also has MS, and while the progression of her disease has been very slow, who knows what our situation will be in 10 or 20 years?
Hell, I could keel over with a heart attack or die in a firery car crash on my way to work.
Life is short...
... buy a bigger boat (that is what I keep telling my wife!).
Greg