I enjoy it for what it is, a cute little dark ride that never has a wait. I was never a huge fan of the Country Bears, so I can't say their closure affects my personal view of the ride.
The obvious reason I, as do many, consider it a disappointment is that prior to its' opening, other Disney parks already had superior Winnie the Pooh rides. As someone who has been to Florida and Tokyo, this ride feels like such a letdown in comparison. Hunny Hunt is amongst the best Disney attractions in existence, while Pooh at DL is average at best.
It's disheartening to see Disney take a step backwards when it comes to cloning attractions. Just as it is appalling they built a POTC in WDW that is inferior to the original, it is disheartening to see Disney build a Pooh ride that is inferior to what came before.