Not that common. As a GA pilot with skydivers yes a few times mostly my mistake.
But as a pax once only. Madrid on an already delayed flight. A go around. I swore realising I was going to miss my connection but realised I was scaring the lady beside me. I apologised explaining that most likely it was an aircraft slow to clear the runway. One of the pilots came on the rt and confirmed that so I looked good.
Anyway when I eventually met my friend who happened to be a flight attendant training to be a pilot. She told me that she had only one experience of a go around. Which surprised me. But it is rare and frankly no big deal.
If anything proof of the safety of airline flying.