Certainly when I learned the song as a child I didn’t know or understand that God was speaking metaphorically. After Ike hit Galveston and Sandy hit the East coast I sometimes think he also meant it literally.
It is true either way. Now I have all kinds of songs running through my head with words such as Rock and Foundation in them. :)