The explosion of the USS Arizona during the attack on Pearl Harbor caused a significant amount of destruction and casualties, including the release of heavy fuel oil into the water, leaving survivors struggling to escape the fiery pools.