There are a number of pathways these drugs hit - dopamine receptors, they slow processing of food, and in tirzepatide's case at least increase insulin response. They're not just small portions in a shot.
I take "Studies show it just doesn't work" to mean "Studies show telling people to eat less and exercise more definitely doesn't work," as opposed to "caloric deficits don't work".