Beyond just being drunk, this emoji is also used to express the blissful feeling of being 'drunk in love,' completely captivated by someone's charm. It would be effective to use it with a photo of someone you like, right?

Among the various emojis that represent a dizzy and confused state (😵‍💫, 😵), 🥴 has a slight smile, giving it a positive or silly feel. Therefore, it's more often used in lighthearted contexts, like chiding yourself for a foolish action or expressing affection, rather than in serious situations.