Keep in mind 2 nations within the UK didn’t want to leave along with a large chunk of the other two.

Irrelevant. It is like saying the Lombardia and Veneto do not agree with what Italian government decide: it could be true but they cannot do whatever they want, they are part of Italy.