If public opinion and vote was honored there never would have been an EU, just ask the French.
France held a referendum on the creation of the EU in 1992, and approved it.
You're thinking of the 2005 referendum, which was about the TCE. The EU already existed before that.