I was pretty well accepted that an attack was coming. Most high-level people in the US Government believed that a Japanese attack was imminent.
The problem was... where?
It seems that most believed that the Philippines were the most likely target, followed by other US possessions that would serve to strengthen the defensive ring that the Japanese were building.
Very few people thought that it would be at Pearl Harbor for any number of reasons.
There was also a group who thought that no attack was forthcoming, but that there would be a formal Japanese declaration of war first.
One of the biggest reasons why no one expected the scope of the multiple attacks that came is because there was relatively little concrete information on Japanese naval capabilities. In fact, it wasn't even known how many fleet carriers the Japanese had. IIRC, many thought that there were no more than 5 total carriers, when the Japanese had 12 fleet carriers -- 6 heavy, and 6 light. That assessment had to be dramatically redrawn just by the scope of the attack on Pearl Harbor.
What's inconceivable to me, and to many, is just how badly Douglas MacArthur failed in his initial defense the Philippines given close to 12 hours advanced warning after the attack on Pearl Harbor. Again, it was largely an underestimation of Japanese capabilities. No one expected the Japanese to launch such a coordinated attack, and with heavy fighter cover, from Formosa.
I've never bought the entire conspiracy theory by the US Government. Never explain by conspiracy what can be clearly seen to be poor coordination, poor preparation, and poor execution.