National weather agency boss defends 'yellow' alert despite huge scale of flooding and disruption in north and south Wales