They just didn't understand the downsides.
The Qs were all ginned up about leaving until the Government of Canada presented them with a bill showing their share of the national debt that was payable upon exiting. It would have turned them into North America's first third world country (not really, I just liked saying that at the time). That shut up those Pepsi-drinking, unfiltered cigarette smokin', poutine eaters.