There is no instruction manual for event like this, but I would never count on my brain and memory to remember 12 or 24 seed words,
I could always mix the order or make some other mistake, and if society collapses that would probably be a global event and not just local.
Having backup phrase hidden in multiple safe locations is much better option, and you can import it in any other hardware or software wallet that uses same seed phrase standard.
Problem is that economic and society collapse would affect internet, communication, electricity, food and everything else, so your best bet is to wait for all systems to be restored.
It is hard because the more places that you store your private seed the more chances of it being discovered by some one else. I recommend 2 highly secure places to store your seed because any more will not increase the security of it any more than storing it in 2 separate places but it will reduce the chance of someone discovering it and taking your Bitcoin. Economic collapse would not be as bad as a societal collapse. A economical collapse might be good for the adoption of Bitcoin because people would lose faith in the current money system. We have had recessions which people look for alternatives and I think that is one of the reasons that Bitcoin gained traction in the early days after the bank bail outs.