Exactly how is educating people and giving them facts "giving up"? Equipping people to make rational decisions based on evidence and giving them the confidence to make changes - that's a slow process.

There seems to be a trend for humans becoming brighter and more socially connected. (See Pinker's decline of violence work.)

I'm making the assumption that those trends will also stamp out boneheadedness with regards to prohibition.