CNBC ranked only red states as worst to live in, but Census data shows Tennessee, Texas, and Utah are leading the nation in population growth.