That isn't an "F" school though, it's a "C- school." Though it seems really, really hard to score worse than a C- on Niche (there are no schools in my district that score worse than that, for example).
My argument however was not that parents should feel comfortable sending their kids to the worst of the worst schools in their district. While I don't think that has serious impacts academically (I know people who did this with their kids, and they're fine) I would worry about the social impact on my kids if they went to a 95% black school where essentially all of the student body was low income, for example (their magnet schools have all been majority black, but more balanced than this). There's also serious concerns about safety, lack of school resources, non-existent PTAs, etc.
FWIW, the neighborhood K-8 I am zoned for is ranked B-. As I said, I find it totally acceptable, but at the time my daughter started kindergarten we lived in another neighborhood which had a worse neighborhood school (rated C). The neighborhood high school is ranked C-.
My son's elementary school, and
my daughter's middle/high school, are both rated B...which considering the diversity in SES, really undersells both schools. I've looked into the standardized testing when disaggregated by race, and the white kids score as well as the top suburban schools, and the black kids score much better than at the neighborhood schools (though not quite good enough to close the achievement gap)
One weird thing I've noticed as I've gotten older though is how segregated kid social groups are. My daughter had close black friends in elementary school, but drifted away from them as she got older - all of her friends are white/Asian now (which is saying something since the school is around 2/3rds black). My son's school is closer to 50/50, and he's literally never had a black friend - which seems odd because I know he's still young enough he doesn't really understand race (like, one of his good friends has an adopted younger brother who is black, and he swears that the two look alike).