Hi, for failover the private endpoint will automatically connect to the new primary storage instance after the failover process has completed.
You should not need to do anything else other than initiate the failover even though the storage account is failed over to a different region. It will just take some minutes for this process to complete.