Translation is often as much art as anything else. Different syntax, word meanings (sometimes a nuanced difference, sometimes additional differences), idiomatic phrases, changes due to antiquity, jargon (i.e., language peculiar to a particular area, e.g., theology - “consubstantial” coming to mind), interpretive overlays, simplicity or complexity of meaning or structure, the goal of the translation, the audience for the translation, etc., all are intersecting and all have their points.
So, were the former translations “wrong?” No, but other considerations clearly have led to the changes we see. Is the new translation “better?” Depends on the factors above and what weight you deem appropriate to give to each.
I find the new translation preferable - as apparently does HMC. The new translation does adhere more closely to a direct translation of the Latin. That has pluses and minuses. I certainly prefer “consubstantial” as that is the traditional translation of “homoousia” which was soooo fought over at Nicea. IMHO for historic and precision purposes, it is much better than “one in being.” (I note, it is a “big” word, which should be used as an opportunity for catechesis as well as a history lesson. Others would claim that the Mass is not the place to use such a word. Reasonable people can disagree on that.) HMC has clearly changed Her mind on the issue.
Actually, I think the opposition is really all driven by politics. The wild experiment and manhandling of the Mass of the post-conciliar period is over. I believe, that’s what this represents to the opponents - and they don’t like it.