Ex-Tropical Cyclone Alfred has drenched south-east Queensland bringing flash flooding to Brisbane and the Gold Coast.