He revealed that in the face of failure, the U.S. was forced to consider halting its support for Israel—as was publicly declared and reportedly conveyed to Yemen