Here’s the writeup for the sleep/wake mechanism: Improving the UX of rent with a sleeping+waking mechanism
Essentially, this degrades to “if you want to do something with a contract that got accidentally deleted, you just need to send a bunch of extra Merkle proofs along with your transaction to bring it back, so it’s kind of like the stateless client model”. I actually think it could be designed to be pretty tolerable.