In my opinion, no. I wouldn't even say it's the best ride at WDW, it's a good ride but the best?
As far as what type ride it is. It's a virtual ride, think a mix between Soarin and Star Tours. You wear 2D glasses, sit on a motorcycle type vehicle and kind of lean forward. You will feel the animal you are flying on breathing between your knees, your vehicle will kind of dip and sway. There are about 6 or 8 in a room. I used to ride Soarin (refuse to now because the Eiffel Tower shouldn't lean) and it never bothered me. Don't ride Star Tours (although did last week to see if we remembered it correctly) it makes me a little sick. FOP made me more uncomfortable than sick. I couldn't keep the glasses on, I have a freakishly small head so had to hold on to them with one hand the entire time. The first time we rode it, having my sternum pressed against the front caused my reflux to not be happy, I kind of flexed my arms while the ride was setting the second time and didn't have that issue. I wear reading glasses but there is a certain distance that with or without my reading glasses is difficult to see (I need to go get real glasses but I'm vain what can I say) which was just the distance the film is so it was always a little off for me. I won't ride it again unless my son is along because he loved it, saying it was the second best ride at WDW (ToT being our favorite ride).
We went at rope drop the first time we rode it, we were at the park around 8:10, went right through the tap stiles, waited at Pandora until probably around 8:45 then they let everyone in. We didn't even do the entire ride line and were off the ride by 9:15. The second time was that same night, we got there around 8:30, wait time was posted 120 min, it was actually around 100. Frankly, I probably wouldn't wait more than 45 min. for it if it were up to me.