When they piss on the piss-splashing paint, it splashes them with piss, so they stop. I believe the point is that it sprays back at all angles.
I'm not claiming it's a magic bullet, but I am claiming that if you think this is about homeless people you are not thinking about drunk people and tourists, who are the genuine target.