This would trigger quite often. On average a block is generated every 20 seconds. Some times a block is missed. But generally the approach to check the TIP is a very integrative approach. Any issue would be identified by it.
In this post I described how I’m running my TIP Check. If it’s not reporting updates for a defined time period I consider the node offline.
If you want to automate the failover it is important that after the switchover the older server also knows that he should not come up again. E.g. if it was a networking issue and is reloved laterwards the node should find out that it is not the active node any more and must not start as a validator.