I mean what matters the most is the privacy of your seed phrase. If you get it stamped in a titanium plate and still it's accessible by anyone in your family or work place, it's waste of money.
People have to think of how they store their backups in metal plate forms before buying these plates for their backups. I agree with you that at the end, how backups are stored safely and secretly to keep them safely from damaging threats like water, fire, acid, ... and out of curious and greed eyes matters.
Backups can be made in any format, digital, physical, paper, plate, whatever but if you fail to secure your backups and let it destroyed or stolen, you lose your bitcoin.
What I suggest is to have multiple backups, this way you will have nothing to worry about but it also brings the first point (privacy) a void. Just make sure to keep it safe and Titanium plates or stainless steel ones are always better than paper.
It's a good advice and for further advice, I recommend
How to back up a seed phrase. Newbies need to read it till the end and pay their attention on note that has an important reminder, test your back up.
Test Your Backup
Regardless of which backup scheme you choose, if you don't actually do a test run of restoring a wallet from it, you can't be confident that it will work when you actually need it.
How should you go about testing your backup?
Create a new wallet.
Create your seed phrase backups.
Deposit a small amount of funds into the wallet, like $10 or $20 worth.
If possible, create a new wallet with a different name, otherwise delete your current wallet.
Initialize the new wallet using your seed phrase backup, make sure the funds appear in the wallet, and that you can spend them.