It's a catastrophe waiting to happen.
People are already really struggling to find EMS practices around Nottingham/Surrey because the universities don't have their own teaching hospitals, so outsource to local practices, meaning students living in the area but attending another university have to find (and, more importantly, fund) practices away from home. This will affect poorer students that most, which may in turn lead to a decline in poorer students applying to do the course in the first place. Harper Adams will only add to this mess.
Current vet schools are finding it increasingly difficult to attract and maintain clinical staff to teach students, as more and more new schools keep cropping up.
More students = decreased number of experienced vets able to teach = diluted clinical abilities of students = further decrease in mental health = increased number of vets leaving profession* = further employment crisis
*both newer grads and more experienced vets who have, unsurprisingly, burned out
It's clear universities know that a VetMed degree will always attract a huge number of applications, and thus money - and this is clearly what a new vet school is all about. Money money money, without thought or care for the real problems underlying the veterinary industry (poor working conditions, work-life balance and pay which will only get worse by adding more new grads) which will just result in more vets migrating to countries with better pay/work-life balance (ie Australia, Canada) or leaving the profession altogether and leaving behind more and more inexperienced vets to pick up the slack.
So in summary, no, a new vet school is not good for anyone except university chancellors.