Hydro is indeed clean in that it does not emit greenhouse gases. Sure, it disrupts life around the dammed waterway. But that's way less of an impact than climate change.
In comparison to FF it’s small of course. But it’s billions of tons, globally more than Germany’s footprint. Which is larger than most peoples assumptions, hence the “huge”.