I’m not sure what you’re aiming for when you kinda proved my point.
You cited a youtube video, something that would be inaccessible during doomsday as a source of info, and the whole point is to have all the power supply and survival solutions in place before doomsday and the youtube video would be pointless.
Look, unless it’s a slow decline where you have some access to power and time to develop survival tools and skills to use this box it’s pointless as you’ve already developed the survival tools and skills. As an archive of other skills and knowledge it’s only as useful as the longevity of the storage media and the devices used to access it (monitor, keyboard, pi, etc).
Note that I already said you’d have to have all the survival and power requirements in place before doomsday. Not waiting until doomsday to use this box as a tool to learn how to survive. IOW if you’re not already a prepped prepper, this box is pointless.