Why garbage? For 2 main reason.
First reason: the methodology. They way those correlation studies work is that they study large number of people (here 130k) over long period (here "up to 43 years").
They want to study "effect of X on Y". Here X is "consumption of red meat, processed or not" and Y is "dementia".
So what they do is they periodically ask "how much of X do you do". In this case apparently "how many servings of processed red meat you eat per month", "how many servings of unprocessed red meat".
Would be able to tell a precise "how many servings of processed red meat you eat per month"? Like, what is "processed meat"? What is "serving"?
If you're not taking meticulous notes you have not hope of answering this precisely, from memory. And let's face it, those 130k people are not fastidious scientists, they just answer a periodic survey that has no importance to them.
The opposite of "precise" is garbage. And garbage data leads to garbage conclusions.
Second reason: confounding of factors. No controlling for other variables. What if dementia is affected by heavy drinking, heavy smoking, drug use, lack of muscles or excessive sugar / carb intake?
What if heavy drinking is the real causation with 54% increase in dementia and the 14% correlation is purely coincidental i.e. in this particular 130k population, heavy drinkers are also eaters of processed meat?
You should ignore all those kinds of studies. They are all garbage.
There's also a general strand of anti-meat studies.
When you study "effect of eating X on bad outcome Y", then you'll find a correlation to something at some point. It's just a matter of time. The more studies you do, the more likely you'll find a spurious correlation.
Somehow the studies of "eating meat causes bad Y" get a lot of press, including landing on HN page. When was the last time you've seen a similar study for vegan diet or drinking soda or eating candy?