OP it entirely depends on what your local options are.
Where I live, there are many small village state schools, who whilst starved of funds, are nonetheless excellent learning environments, with caring committed teachers. Even the richest people in the area (and there are many) don’t generally send their kids to private primary.
There are 2 state secondary schools in catchment, both very good. Both schools are able to fill their teacher vacancies, they have committed head teachers, the standard of teaching is generally good, and the kids have plenty of opportunities to thrive.
The nearest private secondary school is about 45 minutes away. It is, I hear, absolutely excellent. But parents who send their kids there will have to commit to doing loads of driving to visit school friends in the holidays etc, which would have really put me off (if I’d had the money to consider it).
But it would be a completely different story if you had a local excellent private school and only crap state schools to choose from.