Hello @David Ibrahim ,
Apologies for the delay in response.
I understand that you would like to know if one Azure VPN Gateway in Active-Standby mode can connect to multiple on-prem VPN Devices via BGP for Redundancy.
Yes, you one Azure VPN Gateway in Active-Standby mode can connect to multiple on-prem VPN Devices via BGP for Redundancy as shown in the below document:
But you are also using APIPA BGP IP.
Specifying multiple APIPA addresses is only possible when active-active configuration is enabled on your Azure VPN gateway.
As you rightly mentioned, an active-passive VPN gateway will only support one custom BGP APIPA.
Refer: https://learn.microsoft.com/en-us/azure/vpn-gateway/vpn-gateway-howto-aws-bgp#architecture
If you use active-passive mode on Azure VPN gateway, then only the primary connection/gateway instance will be the owner of the Azure APIPA IP. And hence you will see one tunnel connected and the other in connecting status. This is expected.
The active-passive mode with multiple on-prem devices is possible with BGP but not over custom APIPA BGP IP addresses. APIPA BGP method requires active-active mode.
Kindly let us know if the above helps or you need further assistance on this issue.
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.