No, it's not that obvious. Not if you actually study the context the story was written in and the history of the book. The ancient Jews most likely did not know of the intoxicating properties of the cannabis plant. After all, they lived in the frickin desert, where there aren't that many weed plants.

Next you're going to try to tell me that the Tree of the Knowledge of Good and Evil was weed too, and the fruit that Adam and Eve ate was really just a fruity nug that they smoked.