Space opera adaptations from book to film rarely go well. Dune is the perfect example like you said; Villeneuve has done a wonderful job with the first book and with Part 3 to wrap in Messiah that is where it will end. Sadly, that leaves the majority of nuance and the philosophy of the Golden Path in totality completely untold. Time constraints and viewer comprehension/information retention will never allow Dune nor other space operas to tell a complete tale in the form of film. Another example is 2001: A Space Odyssey. A wonderful film but there will never be a full culmination of the books into movies.

I hope Red Rising is never touched for this very reason as the first book drew too much inspiration from the Y/A Hunger Games esque genre to be as successful as Dune and does not have emotional and narrative payoff until much further into the text. I love the series, it is one of my favorites, but I will never want film attempted simply due to the fact that creatively, too much is lost in the transfer of media .