Yes, and no! But let me explain...

first time experience riding this, there is no other experience like it at WDW in my opinion. It is AMAZING. It is also worth a wait, but that is subjective for everyone how long you are willing to wait. To avoid the lines for FoP if you can’t get a FP+, plan to rope drop and get there WELL before the park officially opens. They start letting people inside to line up before that time. (I don’t know about lately, but in summer 2018 we were able to
ride it before the park was even open,
but idk if they are still opening the ride that early or just letting people line up early).
For my “no” answer... now that I’ve ridden the attraction SO many times, a little of the Magic has worn off. I still love it, and NOTHING compares to riding it for the first time, but at the end of the day I still prefer a real rollercoaster like Expedition Everest. It’s my fav! But yeah... definitely a Must-do at least once!!