AFAIK the only failover for FWD that ever sort of worked is:
/ip dns static
add type=A name=myns.tld address=x.x.x.x
add type=A name=myns.tld address=y.y.y.y
add type=FWD name=example.net match-subdomain=yes forward-to=myns.tld
It’s far from perfect, because it’s dumb round robin. First query goes to x.x.x.x, second to y.y.y.y, third to x.x.x.x, and so on. If current target server doesn’t respond, query fails. But next query will be sent to the other server and response will get cached, so subsequent queries from other clients will get that. It’s better than nothing.
Multiple FWD records don’t do anything, router will always use the first one. If it’s dead, too bad.