The setting unloads eligible background tabs to free memory, then reloads them when you return. The useful part is knowing which tabs it leaves alone and when to add an exception.
Browsers can fetch pages before you click when they predict where you are going. The result can feel faster, but it may use data and contact a destination you never open.