It sucks to hear, but moving is the name of the game as a new pilot in this industry. You might make it work staying put, but it’s going to take twice as long and you’ll see way less of your family once you start commuting to a new job. Even a three hour drive starts taking its toll.
Can you really not move your family? How long did it take you to get 500 hours? Commuting and living separate from family gets very expensive. I recommend just sticking with what you got until you can get to a regional.
Is the military an option for you? Would you consider it?