Damn right. One decision that causes a cascade of others, each costing money, taking time & introducing risks...
It should either never have been started or cancelled much earlier I suspect. My personal nail in the coffin moment would have been the engine selection - there was apparently a Honeywell engine with better fuel consumption but of the same dimensions as the existing engine which would have fitted in, but that was rejected in preference for something with more power. At that point, you now need new wing boxes, you've already built a wider body fuselage and you're fitting new engines - to something, which as has been mentioned, was a collection of bespoke parts.
And we *knew* this would be a problem because when the Nimrod AEW program came up, they were careful to match the wings with the fuselage because it was understood that the parts were not a mass-produced fit.
I've seen a list of proposed replacement engines. Some would have run into the same problem as the BR710. Others might not, which would have meant no need for the wing box replacement. And there was the possibility of refurbishing the Speys. It should have been possible to get a bit more performance & keep them running for long enough.