It seems like the article is making exercise more mysterious than it is. From what I've read, scientists seem to be more knowledgeable than the state of confusion this article is giving out.
The benefit of exercise in terms of weight loss is that it increases your resting metabolic rate (RMR). So the greatest caloric expenditure is often not during the exercise activity itself. I used to think that it's impossible to burn off the calories eaten from a burger. Now I know better.
Of course, exercise is only effective if your diet complements it. It's not either or, it's both. Both contribute to a net caloric deficit or surplus, creating weight change.
They also don't go into enough detail about the types of exercises. HIIT and weightlifting are particularly effective towards increasing RMR.