Hogan was not the reason why the ratings were dropping. The ratings were dropping before he even came to the WWE. The ratings started to drop all because of the weakass Invasion angle. And the WWE has yet to recover from it.
Hogan during his stint did do well for the business side of things. He sold tons of merchandise(Spelling?), attendence figures started to rise, and crowd heat was up, because of Hogan.