How to know when to give up?

I am a freshman at a private school. I have gone to private schools for four years and the process is always the same. I'm doing alright in the beginning of the year and my parents are proud. My grades steadily decrease and I start to dislike ally friends my arenas begin to get on my back about them. I then waver on the brink of flunking out of the school and me and my parents have heated shouting fights about my academics where they basically call me stupid over and over and ask questions to which I have no answer. These private schools are not for average students, they are made for advanced students but I always struggle. The only alternative is going to the school I'm zoned for. O did a year of non private school back in elementary and I fit I'm terribly and I was considerably more intelligent than all of my pupils. So the question is, is school worth having a bad social and family life if I can't even pull good grades or should I go to my zoned school which I think will make my parents silently resent me forever?