You're feeling real throttle response vs the laziness in Normal mode.I also think the engine is mapped differently in normal versus sport.
Yeah I had to do that today due to a pop up rainstorm for the longest time I have used the Weather Mode, I really liked how the car drove and the mode.Sport mode. If roads are wet I switch to Weather mode.