Only you can make the decisions for your life.
You are, however, showing very strong tendencies toward predetermining outcomes. This tends to make them come true, as we take the steps to make those predetermined things occur.
Being open to trying the uncomfortable, and seeing where it takes you, is more difficult but is worth trying if you have a relationship you want to have any chance to preserve. You certainly can't tell him no, he can't go, if you actually love him because that's cutting him off from his dreams (which generally results in bitterness and resentment and lots of "what ifs" if no replacement for those dreams materializes).
You can choose to try to continue your life without him, or embark on a long distance relationship that cannot remain long distance forever. Either will be difficult.
Brian AKA Bri the Tech Guy (website in my user profile) - Windows 10 Home, 64-Bit, Version 1803, Build 17134
. . . the presumption of innocence, while essential in the legal realm, does not mean the elimination of common sense outside it. The willing suspension of disbelief has its limits, or should.
~ Ruth Marcus, November 10, 2017, in Washington Post article, Bannon is right: It’s no coincidence The Post broke the Moore story