This sounds a bit doormatty. Whatever your children want you wll consider it.
Forget,(for about) 10 minutes the expected new arrival and ask your self two questions
1) Do I really want to upsticks and move from an area where (presumably) I am settled and have friends and to some unknown part of the country where I know no-one, have no idea whether I will like it or not and I could end up very lonely.
2) If I had to move, is where DD lives an area I would like to live in? If it isn't do not move.
A lot of people in your situation have acted on the request without careful thought, carried away in a cloud of grandmotherly love, only to deeply regret the decision later for all kinds of reasons.
Think long and hard about your decision.