Dramatic footage circulates social media as flood alert in effect for most of the Welsh coastline