Ofsted inspections, like MOTs, are 'on the day'; the judgement as a result of one / a pass in the other stands until the next inspection, even though the same result would not necessarily be found even if that were undertaken the next week.
One place to look is Parent View
https://parentview.ofsted.gov.uk/parent-view-results/survey/result/24387/current
Assuming that's the right one - if it is, then (possibly optimistically) the Trust should have made efforts to rectify the issues which gave the school its 'RI' grading. Looking at the Ofsted report, a main complaint was that pupils were allowed to drop art, music and drama at the end of year 8 (although, bizarrely, being able to pick these up again for year 10 - Ofsted s beef being that too few actually did so and therefore the curriculum was narrowed too much, too early for them). The current 'curriculum' area of the school's website definitely says that it runs a three year Key Stage 3, and gives details at least of the curriculum for Art (the only subject I looked at) for year 9, which does give the impression that this particular Ofsted criticism was taken on board.
Other ideas: ?join a local Facebook group if there is one and ask there / search for existing discussion(s) about the school.
?ask your neighbours whether they know anyone with DC currently at the school, or have recently left.
I am not familiar personally with this school (or any school of the name, if I've managed to find the wrong one!) BTW.