I don't think we're likely to replace alcohol any time soon - even with other relatively popular things like cannabis. The effects are more predictable and enjoyable by more people.

There's even some evidence, perhaps of questionable quality, but it makes a good story at least, that we may have evolved to prefer alcohol despite its toxicity because it was a reliable source of safe drinking water.

And even newer theories saying it may be related to the smell of ripe fruits leading to some primates getting a better source of energy.

In any case human affinity for alcohol likely goes back very far.