First off, according to credible anecdotal evidence, FDR did not think so. That's number one.
Credible anecdotal evidence from whom? Just saying it doesn't make it so.
What was said, who was it said to, what was the context, when was it reported, how did the person doing the reporting come into possession of the quote? Little questions that would allow people to make a reasoned evaluation of the matter.
Two, it is hard to fathom how some of you folks can think that "catching them in the act of trying" would have had anywhere near the emotional shock value of a devastating surprise attack.
To the generals and admirals on say December 5, 1941 - "We have credible intelligence that a major Japanese naval task force is steaming towards Pearl Harbour, the Phillipines and towards Hong Kong. Take all necessary measures to protect military assets. Fleet to sortie ASAP and proceed to (co-ord). Engagement is authorized."
To the American people December 6 or 7, 1941 - "The US Navy, and US Army Air Corps, detected and engaged a Japanese Naval Task force in the North Pacific which was in the process of launching an attack on US possessions at Hawaii and Wake Island, with heavy casualties on both sides. The Phillipines have also been attacked in a nearly simultaneous attack by Japanese Imperial Forces. As of this moment, the United States is at war with the Empire of Japan."
Either way, you're at war.
If we follow the various "catch them in the act" scenarios, all sorts of thorny and potentially explosive questions would have arisen. If we had put PH on alert and caused the task force to turn around, that would hardly have jolted the American people into supporting going to war.
You still have to deal with the attack on the Phillipines.
If we had pulled off the impossible stunt of putting PH alert without the local Japanese noticing it, and if our forces had then put up a terrific fight when the Japanese attacked, (1) our losses still would have been horrendous because we still would have been markedly outnumbered and outgunned. and (2) tons of troubling, potentially explosive questions would have arisen about foreknowledge. Also, a battle does not evoke the feelings of outrage and shock that a surprise attack evokes.
You're still hypothesizing that the Japanese agents could have gotten word to Japan in 24-48 hours, who then would have been able to get word to the fleet in time.
You still have the effect of a sneak attack, its just then you get the added morale boosting effect that the int boys were able to detect the sneak attack and neutralize it. Given that the US would have gone from "tense, but still peace" to "war" in a very short period of time you still would have had the shock to the system of the general population.
Again, we have credible anecdotal evidence that FDR believed that the only way the American people would support entering the war was for us to suffer a surprise attack and to incur substantial losses (though apparently the losses were more severe than he thought they would be).
Again, your source for said anecdote.