The rain water is getting between the exhaust and a heat shield and violently boiling there. I had this happen on my 98 Neon all the time in heavy rain. It also can be felt through the floor, if you feel in the right place. No need to gun it, just drive on, it should boil out shortly.
