I have seen this very randomly on SMSs for years on various iterations of iOS and iPadOS. I assumed it's just yet another bug to add to the ever-increasing list.
For some reason, Apple do not treat SMS the same. So if you delete an SMS off your watch it will not delete off the phone or iPad and vice versa. Absolutely crazy decision by Apple. But let's be honest, they aren't the brightest.