The actual solution is network prefix translation. You effectively NAT the primary network when failed over to the secondary. See https://docs.netgate.com/pfsense/en/latest/recipes/multiwan-... for an example.
If you want "real" failover, get an ASN, your own prefixes, and run BGP. I know that's not for everyone!