Odoo is using this method in stabdard

@http.route(['/website/social/<string:social>'], type='http', auth="public", website=True, sitemap=False)
def social(self, social, **kwargs):
    url = getattr(request.website, 'social_%s' % social, False)
    if not url:
        raise werkzeug.exceptions.NotFound()
    return request.redirect(url, local=False)

means if you would like to override the links in the footer, it's better to do it in the xml view [settings -> technicla -> views] search for footer of you corresponding website and change there

But you can also stay in standard as odoo will compite /webiste/social/[the social stream] and will call the method above which will call the setting done in your company, means the socil inks you done for your company

So just change the social links in res.company (settings-> users & companies -> companies) and leave the footer links as they are in standrad

hope this helps

warm regard