Speaking as someone who actually worked in the industry: he didn't take it down. The actual troubles started long before him, and even long before 90s; they weren't noticeable at first. In 70s, those bright rocket engineers who were given carte blanche for almost anything after the war (and showed it was worth it), started to abuse their positions to siphon resources from the state and to justify the existence of companies led by them. It was roughly the same process that was happening in NASA after Apollo, except NASA realized that early on, and somewhat corrected by starting to shift the spaceflight towards the commercial/private sector since 1985. Additionally, NASA never suffered a disintegration of the country and a decade of nothing.
Rogozin was just a typical okay-ish manager of Putin era with an inflated ego, who also liked to shitpost to Twitter. The ones before him were even worse (like Komarov who plundered Khrunichev together with his friend Kalinovsky). His main blunder was that he tried to run it as a for-profit state corporation to cater to the government unwilling to pay more for a hopeless industry; otherwise, some of the decisions he made were sensible enough. But the Russian space industry couldn't have been "saved" by mediocrities like him. It needed to be rescaled and the program re-prioritized. The fundamental reform was long overdue, and it required political will from the government, that wasn't there.