Wealthy people keep ditching California and New York for Florida and Texas — but their moves could actually hurt the South's biggest draw