Politicians have queried why only a yellow weather warning was issued for areas including valleys in South Wales, which suffered a month's rain over two days, rather than an amber or red one.