You are the only one can make decision for you and your family so make sure that you did your homework well, may be search little bit more on the school then make your move wisely. Unfortunately nobody can tell you the future.
Unfortunately nobody has a crystal ball. The school rated academically acceptable. I can totally understand and don't understand how an elementary school cannot achieve an exemplary status or at least a recognized one.
If you still like Castle Hills, you may want to look at a pre-owned home zoned to the Castle Hills elementary which is rated exemplary.
Kids can be taught by the best teachers in the world and still do poorly if homelife doesn't support a desire for education and respect for school.
So, if a year out, the school doesn't yet have the highest rating, I'd say give it some time -- it may just happen. Also, regardless of which school a child goes to, show interest in their classwork and homework, and they will succeed, even if the school is never more than Acceptable.
If you are thinking about buying new, we suggest you always use a Realtor. Remember the building reps are always nice and friendly, but they are working against you and not in your corner. Building is tricky and you need someone in your corner looking out for your interests.