This comes up regularly, and so much depends on factors that we're not aware of.
You have a great job, but is it transferable - and how long before you retire anyway?
You would free up money - that could be very useful OR it could mean that if you want another move, you won't have the same capital.
Where does this sit in your life's priorities?
I have a friend who has recently done this, in the following circumstances:
The grandchildren are the only ones she is likely to have; the nature of their parents' jobs mean that standard childcare only covers some of their needs; her greatest friends don't live nearby anyway; she is retired. So she was happy to move and get a new circle of 'local friends' and pursue interests near her family.
The suggestion is often made here that you try renting out your own house and renting near your family for several months. However, I gather that organising this is more difficult than it used to be, and probably doesn't fit with your job.
Whatever you decide, embrace it wholeheartedly and make the very most of being the 'interesting more distant' nan, or the 'making a new life here' retiree.
good luck