If the foam cannon left a clean car, without a hand wash then everyone would be an expert detailer, and there would be no reason to have to polish anymore.
Anyways, the only expectation I put on my foam gun/foam cannon was to loosen the dirt already on the car, thus allowing for an easier wash.