DNS resolve to backup/main static ips?

We have dual wan on our firewall/router.

WAN 1 = main

WAN 2 = backup

Both are static IP.

We have a camera server port forwarding to both.

We would like to setup a DNS record (houseNVR.domain.com) that will resolve to the main static IP, and if it can't reach it, it will resolve to the other backup static ip. I'm guessing it would need to ping the port or something to fail back and forth?

Does such a DNS service exist? We use AWS. Maybe route 53 has something like this?