It obviously depends on the schools in question, and the child. If you visit the schools your decision should become much clearer.
Our local primary school is not great; it’s tiny, composite classes, disruptive children (several children have left because of it), very little in the way of extras eg they bring in external teachers for PE and they regularly don’t turn up, and safety is lax.
The school our DC go to has: excellent academics despite being non-selective (one DC is top 4% maths at national tests and is in 2nd set maths), specialist teachers for all subjects at age 9 plus, curriculum is broad including Latin, languages, geography, separate sciences, art, drawing, stem, coding, design technology (all specialist subjects in specialist rooms), they play competitive hockey, netball, cricket, tennis, rugby, there is an on-site swimming pool, two libraries, outstanding music provision (the school is known for music)
And most importantly our children are very, very happy. Any issues are dealt with very quickly and the school are able to adapt to the needs of individual children. They have SEN children who are able to be in mainstream education that I really don’t think would be in the state system
I had a truly miserable primary school experience, and it left lasting scars both physical and mental, so for us it is absolutely money well spent.