Welcome.
I think the key to not developing soreness is finding the right thongs for your body. I have found that every manufacturer sizing differs a bit. A medium with one company often fits slightly different than a medium with another company, for example. I have thongs that are sized medium with one place and sized large with a different place and they seem to fit the same. So there is some trial and error to the process of finding the best thongs for your body, sometimes. For me wearing a thing for sleep doesn’t work well, but then wearing anything to sleep in doesn’t work well.
I do encourage you to hit a beach of pool in a thong. It is a wonderful feeling. I’ve been wearing a thing to the beaches and pools for a number of years and have enjoyed the experience every time. As for wondering what people think, I found more positive comments and interactions with people than not. Be confident and enjoy yourself. I hope you make it out in a thong.