The transformation of the BOOK Starship Troopers was to the MOVIE is what happens to a cow after its journey through fast food chain and the subsequent digestive system. Indeed, once you throw anatomical waste at people, very few will wipe it off and perform forensics to discover the real animal it originated from.
It took me 7 years and endless recommendations to shake the Starship Troopers movie and finally read the book.
Will the movies forever taint the Foundation series and prevent generations of young readers from knowing the brilliance of the Seldon plan? I can make educated guesses, and I sincerely hope they turn out wrong.
A sign in a library comes to mind: "Don't judge a book by its movie."
Lavish spending can be disastrous. Don't buy any lavishes for a while.