Nope. Those vacancies will be filled with illegals living on UGI and/or welfare - all while the nation slowly collapses around them.
Notice that the New York population drop is a “net” number—that means that there are not enough illegals moving to New York to replace the former taxpayers and property owners who fled.
California is a better fit for what you described—the net population loss has been slower (on a percentage basis)—and of course the border is a lot closer—and the weather is a lot more pleasant.