Forecasters are warning of 'explosive cyclogenesis' with wet and windy conditions for the end of the week and more on the way