We moved our dc from an outstanding primary to a satisfactory one. If there had been any way at all of commuting back to the first primary, we would have done that - is that an option for you at all?
Basically, we felt that where we lived shouldn't be dictated by the primary school. And, let's face it, if we're living in an area, it will be our neighbours' children at the local school. It was, after all, a "nice" area - surely the local school couldn't be that bad. That was our reasoning, anyway.
It was a shock.
The difference, certainly in this instance, between outstanding and satisfactory was .... well, let's just say it was quite something. And the really interesting thing is that if a school is "satisfactory" there is no real pressure on them to change, unlike "inadequate".
It was not great. The teaching was lacklustre, if not moribund, the curriculum was dry bread, and there was no sense of pastoral cohesion. Facilities and add-ons were minimal. My older one switched off learning completely, my younger never started.
That, of course, may not be the case with your school. It may be fine. But do be careful.
There is also something peculiarly "Alice Through the Looking Glass" about having your dc in a "satisfactory" school, after you've had them in a, perhaps more "ambitious", or "organised" school, in that you, and you alone, will be aware of the new school's slightly desultory quality, whilst all around you are singing its praises. And you may have to watch your, previously sparky, engaged dc completely turn against school.
That said, I would still say you shouldn't let a school determine where you, as a family, wish to live. It's a tricky one.