This is one of my favorite 3-D shows! While there certainly are some kids who don't like it, and it does play on insect phobias a tad, it's also a very cute show. For starters, the theming of the line queue is fantastic! It's one of the best in all four parks, IMO. You get to see the tree up close and all the detail of the animal 'carvings' in the tree's trunk and roots. The show has a very good message, and it's lots of fun.
There are obviously some small kids who don't like this show, but I think most adults can handle it. (and most kids) If you find you don't like it, it is easy enough to leave this show. Try to sit on the far side of the theater when you enter, if you have any ability to choose your row.
It's certainly worth trying once.