Keep in mind this is resale as a % of msrp, not raw $. A 120k Porsche that resells for 70k after 5 years is “doing better” than a 30k Honda that resells for 15k after 5 years, but you still “lost” 50k on the Porsche vs 15k on the Honda.
German trash is still German trash after 5 years. If you buy trash, it will be worth trash. Porsche is the only German car if you are interested in something that is not trash in 5 years. Otherwise, you are buying new trash that will become old trash.
That’s more a factor of lower gas prices driving demand toward bigger vehicles. When gas prices go up again, sedan depreciation will go down and SUVs will depreciate faster. They go up and down so it’s not an easy thing to time. Better to just buy what suits you.