No, you cannot achieve automatic Azure Web App regional failover using only a Private DNS Zone. Private DNS zones are for internal name resolution and do not provide failover or public routing.

For public apps, use Azure DNS Public Zone with manual or scripted updates, or use Traffic Manager / Front Door for automatic failover. https://learn.microsoft.com/en-us/azure/dns/dns-overview