It's not my favorite ride, but I don't think there's a wrong answer. Anything at Disney World is worth experiencing at least once. The scenes are quite beautifully done and it also features one of the most advanced animatronic figures ever made.
If you're a big fan of Avatar, I would definitely recommend it. If you're not and you have plenty of other things to fill your day, I would personally not wait more than 20 minutes to ride it.
It sounds like you do want to ride it, and the rest of your group isn't so interested. In that case, I would suggest trying to get it as a Fastpass. I would definitely ride Flight of Passage (if you're into well-done simulator thrill rides), and then go for it as a FP after you've used your first three. Since it's a boat ride, it has a decent capacity and there's a good chance you'll be able to pick up a Fastpass if you keep refreshing your browser/app to see the latest availability.