I'm not an expert by any means but looking at the code I don't believe 'failover' as you describe it is possible.
When recording (or streaming) is about to begin, TVH creates a 'subscription' to the channel. It creates a list of service and tuner combinations which could provide that channel, bearing in mind any other subscriptions which are already running, then chooses the one which best matches your priorities. I don't see anywhere that the subscription is retried if it fails, or if the service fails while the recording is in progress.
There is a configuration option for recordings "Clone scheduled entry on error" but I've never tried it, and of course it wouldn't work if the programme was broadcast only once.
My TVH setup has multiple DVB-T and DVB-S tuners. Satellite reception is generally more reliable so the DVB-S tuners are set to higher priority.