One longer-term risk is that it will destabilize the whole EU. If the UK doesn't collapse, other countries will ask for the same deal, and the EU will just fall apart bit by bit.

To extend your argument, maybe that wouldn't actually change much in the grand scheme of things! But EU regulations have a pretty big impact, so I think the breakup of the EU would actually be a big deal.