^That was clearly the analogy, but from what I gathered he got wasted by stuffing himself full of those water tribe noodles...so I'm not sure that counts as being inappropriate for children. Indeed, I seem to recall Sokka drinking cactus juice and spending the rest of the episode hallucinating. Was this some moral lesson about drug use being harmless and funny? No, it was just funny.
The relationship stuff seemed harmless enough to me.