We chose DD's school last year based on a viewing we had, Ofsted reports and SATS results. All looked great and we were pleased with the HT at the school so decided to go with it.
When she started in September we found out that the HT we had seen had retired and that the school was in special measures. My initial reaction was to pull DD out and look for something else. It was my fault as I didn't take into consideration the fact that the Ofsted reports I had looked at referred to 4 years+ ago.
However, she has almost completed her first 2 terms at the school. We decided to leave her there because she had made friends, and was doing well ie, she was learning to read at a rate of knots, could write and spell, was doing well with number work and she, ultimately enjoyed being there.
The school has just had its last monitoring visit and is no longer in special measures. Obviously we are pleased but as the new HT pointed out, a school in special measures with a dedicated team will only get better.
I think what I am trying to say, although the scenarios are different is that you may well be surprised with the school and what it has to offer. There's no harm seeing how it goes but obviously appeal if you feel strongly enough.
As for your DH, I am a bit surprised that it was your decision, rather than a joint one. I knew in my head where I wanted DD to go, but DH had to sign the application too and had he not been happy with the choices we made, he would not have signed. I think its a bit much of your DH copping the needle because you made a decision that he now doesn't agree with. Does he not realise it is a bit late to be checking results and stuff once the application has been made?