First time drinking alcohol and it was a disappointment

I (22M) decided with my friends that I finally wanted to feel how it’s to get drunk and feel the disinhibition. I have experience drinking wine in the past but never been drunk, only till the point where I felt a bit off balance.

But things didn’t go well this time- after 3 shots I was just feeling dizzy and off balance an not even a bit disinhibited. I threw up what I had before I drank and for about 15 mins I felt a bit light headed and without any thought inhibition but I was still feeling dizzy. I couldn’t drink anymore, else I knew I would puke. I couldn’t close my I eyes, my head was spinning.

In short I just felt dizzy and not drunk. What a waste of good alcohol!

PS: any tips for not letting this happen again would be appreciated