I had a similar issue on my Pixel 7. Are you using different default SMS apps for different profiles? For me, the stock SMS app would double send, or atleast appear to, messages when I had a setup like that.
I consisently have issues with SMS if I don't use the stock SMS app whether its not receiving texts on secondary profiles or this double message issue. At this point I have resigned myself to just using the stock SMS app. Its not a major issue just a bit of an annoyance.