S.W.
How long is the job for? Will you just work for this TV show or others? Compare the cost of living in GA to CA and will it work? What does your husband do? Will he be able to get work?
Personally I would move but I would rent for a bit to find out what the market is and then buy a house. Homeownership is a big responsibility and sometimes things don't sell when you want.
Your daughter will survive the change and she will make new friends. Is there a child care place near where you would work to care for your younger children?
Every move is an adventure or a new chapter in the book of life. As a military wife moving was part of the package and you adjusted and sometmes looked forward to moving to the next base/post.
Good luck to you.
The other S.