“I've never flown the type, but it seems to me that there is never a time when both transfer pumps would intentionally be off together”
Yep, when main is empty and fuel is only being drawn from the supply tanks. In simple terms, when there is no fuel to be transferred from main to the supply tanks, the transfer pumps are turned off.