I found this to be a very strong conclusion to the CMC arc, and in the context of the show I didn't find the ending to be unrealistic. Afterall, Scootaloo was already living without her parents for years, it's not the same as most instances were kids are forced to move because of their parent's job. The most confusing thing there was not that they all made it work in the end, but why the Aunts didn't move earlier! That whole arrangement was kinda screwy. However, I am in the party that believes it would have been better if Scootaloo did move away in the end. I knew they would never actually do it, but they could have, it's the final season so they don't need to maintain status quo! While her parent's had rushed everything and really should have told Scootaloo about their plans earlier, they did make some really good points despite being the antagonists in the episode, and we could have gotten a good moral about the CMC enduring despite being separated geographically. Instead, we are given a completely unrelatable conclusion to an otherwise relatable conflict (I personally have been transplanted due to a job change much further than Scootaloo would have been, being able to visit once a month is almost laughably fortunate). As some other people have pointed out, the moral for this episode may actually be harmful, as it justifies tantrums, which is a shame because in the context of the episode it actually worked, it just doesn't generalize well. Then there was the part where Scootaloo said her parents were forcing her to choose between her friends and family, but they weren't: they never gave her a choice, and Scootaloo never had to make a choice because she decided instantly that she would rather stay in Ponyville. She never even considered the possibility that they could make things work with her moving, and they could have. People do. There was a lot I liked about this episode, but I'm really disappointed that they didn't take the risk.
One thing I got to mention since no one else did is that this episode implied it's because her aunts don't actually live in Ponyville so they were limited in how supportive they could be, but yeah, your explanation is better.