A Met Office red weather warning is in force for Wales and south-west England during the potentially life-threatening storm.