Does standard comprehensive car insurance automatically cover flood damage?

No, flood damage is usually not included by default. You must specifically ask your provider to add "Acts of God" or "Acts of Nature" coverage to your policy to be protected against floods, typhoons, and earthquakes.