So two immediate questions arise:
1. Do you have a perceived sense of risk/vulnerability to not deleting SMS messages? Why?
2. Assuming there's something more to cover other than #1, what is the problem you are actually trying to solve here?
Google supposedly implemented an auto delete feature for OTP messages within 24h in their own Messages app. I couldn't find it on my dated Moto G7 though (Android 10).
I any app I tend to favourite/pin my most frequent contacts and sources of messages and usually manually bulk delete the rest.
Funny story is that SMS do have a standard for sensitive info (Class 0 - not stored on the device) but I haven't seen that being used since the time of bulletproof Nokias :)
I use email the same basic way, pruning almost every message weekly on Sunday.
Sunday is also Stop Subscription Sunday, like Taco Tuesday, but for software and app rent-seekers.
https://support.signal.org/hc/en-us/articles/360007320771-Se...