I am pertty sure signal backs up SMS messages and if you enable backups, it looks like you might be able to extract them with this: https://github.com/xeals/signal-back/blob/master/README.md
Not great for the non tech-savvy, but I don’t know of any SMS backup strategy that is