One man died in North Wales and there was extensive flood damage to homes and businesses across Wales as the agency's categorisation of the severity of the weather has come under fire