I can’t wrap my head around how this is done. Likely from an interaction.
Here’s an example site: https://sweetiq.com/
Basically when you get to the bottom, as you keep scrolling the footer is revealed.
Perhaps Nelson the Magnificent can figure it out for the next live workshop ?