From the quotes I’ve read from Yamamoto, he probably thought Japan could never win a war against the U.S. He knew the U.S. industrial capability would eventually overwhelm Japan. That and millions of angry Yanks thirsting for revenge after Pearl Harbor.
Yamamoto had lived in and was educated in the US. He knew and feared the USA.