i think you are right... There are many of us that are optimistic and look to the future.
Sadly there are those that can see no light at the end of the tunnel - except a train coming towards them.
I think it depends largely* on your politics.
Those on the left, Socialists love big government, more tax, more government control, more nanny state, cradle to grave care and telling us what we can or can't do. To them, the EU is a wonderful adjunct to government - more regulation, more control and the useful ability to tell us what light bulbs we can use and how big the motor in our vacuum cleaner can be... Plus of course the EU has given us all sorts of things that couldn't possibly be achieved by any of the 168 non-EU countries in the world...
For those of us on the right; we want smaller government, less tax, less control and more ability to make decisions on our own lives. For us, the EU is just another unnecessary layer of government which costs us money. And of course we can see that many of the 168 non-EU countries in the world have many of the 'things' that the EU claims to be their own without paying a £10Bn membership fee every year.
* I read an interesting article in the NY Times the other day by somebody who described himself as a 'Leftiteer' - somebody from the left wing of politics who supported Brexit.