As far as I'm aware, the ride is not meant to be an E ticket attraction and rather be a D Ticket attraction. It obviously isn't meant to be up there with the big attractions line up like Space Mountain or Big Thunder and nobody from Disney has never said so, nor is it intended to be comparable to the likes of what Universal are doing; it is family oriented only.
As for any thoughts on the investment itself, I have absolutely no qualms with the refurbishment's plans to re-invest that area of Fantasyland and love that Disney are giving children and their families new positive experiences based on films that they have, more than likely, grown up watching. The roller coaster is a nice step up from the former Snow White Scary Adventures and Pinocchio's Daring Journey, both basic and charming dark rides, alongside Under the Sea to an extent and also gives young children a chance to build up from Barnstormer to Big Thunder Mountain when they're visiting the Magic Kingdom.
Whilst a couple of members do discredit it for costing too much and being unnecessary, it's unfair to suggest that the younger generations don't need such a well themed attraction to entertain them. The high quality will surely make many children's experiences at the Magic Kingdom much more memorable, what with the addition of the interactive queue elements and lifelike animatronic Dwarfs, alongside any details from the film such as the cottage, waterfalls and animal carvings which look just lovely; it shows that the Imagineers aren't missing tricks with wanting guests to believe they've stepped into the film.
As the final piece in the Fantasyland expansion, it honestly looks to be a great investment for the families overall and a lovely tribute to the original film alongside Scary Adventures.
Also, since the expansion is now over, maybe now we can let Disney get on with making a high quality investment that'll rival Universal's Wizarding World expansion with an orientation for the older family and adult market than believing this was their plan all along? Yes?