Redo footer

Closes #3539618

Testing steps for this are going to be a bit tricky since the work deviates from what's on the latest version of the design. See the conversation here: https://drupalassociation.slack.com/archives/C07AN2SMVNZ/p1755629184200279

Mostly what we want to make sure of is that things look good at all screen widths.