By simply reviewing your list - we came out stupid at some level. The simple fact that Japan was able to do so much damage is more evidence. I wonder, occasionally, if the whole thing was as set up that provided a target - probably not, but it sure seems stupid.
No, there were deficiencies at Pearl harbor to be sure, but it was not a sitting duck. Had the radar been running properly or had the Ward’s report been treated the way it should have, we would have been on alert when the Japanese arrived. The forces there were enough to have given Kido Butai a bloody nose.
The Fleet was moved to Hawaii in 1940 for one reason. That is where it needed to be to deter or fight Japan. Japan chose to fight the US because the US opposed Japan’s invasion of China.
Pearl Harbor was a lucky strike, but not lucky enough, because it only slowed down our response by about six months, tops.