Hi.
By default, client queries the DNS server.The DNS server immediately forwards the query to its first conditional forwarder. After <forwarder_timeout> seconds, if the first conditional forwarder does not reply, the DNS server queries the second conditional forwarder, and so on.
Refer to this document for details:
https://learn.microsoft.com/en-us/troubleshoot/windows-server/networking/forwarders-resolution-timeouts
So I think that there is a high probability that conditional forwarders cannot be automatically switched. You can only switch manually.
Hope the information is helpful.
============================================
If the Answer is helpful, please click "Accept Answer" and upvote it.