I've been watching a lot of "Ozempic experience" YT videos recently because a family member is considering it. It seems like by far the most common side effect is a few weeks of diarrhea. After that, some nausea. Overall, I get the impression that most people tolerate it well if they can accept the diarrhea, but a small portion aren't able to get past the side effects and discontinue.
The more interesting number is that the vast majority of people who discontinue, even after long term use, regain 100% or more of the weight they lost. Weight loss doctors talk about this drug as something like statins which you'll likely need to take for the rest of your life. I think that's the area that needs the most improvement.