With only minor damage and flooding reported, rain from Tropical Cyclone Sean has left residents in WA's Pilbara and Gascoyne in a celebratory mood.