If you're really paranoid, I highly recommend building a SeedSigner, getting some casino dice and generating true randomness, then giving it to the offline signer. It will spit out a QR code that you can write down as well as seed words. You can import it as watch-only into Sparrow and also import addresses into Bitcoin Core. If you use Sparrow, just set it to only ever connect to your own node.
When there is need to send funds, you turn on the signer, import the seed, scan the transaction and send it off.
You should use Bitcoin Core as a wallet too and fully avoid SPV. I have always thought Luke Jr was right from the start, including block size, even tho is not practical to decrease it anymore.
I just had a little look online and it appears that SD cards have more risk than other flash storage due to exposure to ESD which builds up for instance by plugging them in and out. Worth keeping in mind when it comes to storage (anti-static bags maybe).
Even SSDs aren't a good idea for long term storage, including USB pendrives; HDD is still recommended. Of course, it begs the question: how do you even hide an HDD properly if needed.
Personally im moving my tax residence to a "crypto friendly" country ASAP and stablish my "bunker" there and hope the most f*cked up scenario in which even the "crypto friendly" countries get coerced into joining the supranational decision makers of how storing private keys is now illegal. At least I will buy some time to decide what to do. For now it is what it is. I don't see a way to store a Bitcoin Core wallet any other way but to have your HDDs in jurisdictions were they will not confiscate your stuff anytime soon.
Mdisk (millenium disks) may be a good long term storage backup too assuming it is possible to safely store data while being able to edit it which I doubt it's possible. Ages ago I remember using "DirectCD" software to edit CDroms, having some sort of "opened session", but this introduced further problems.