Something like turning off water is something anybody (also the campaign agency) can comprehend. Turning off water safes water, easy.
Now think about trying to reduce exhaust pollution, you can't see it, people don't know how much pollution is generated by a car, and most importantly: there is no easy solution to reduce it. Yes, you can ask people to leave their car at home and commute to work by bike, but that does not work for everybody and reduces comfort for most people.
The campaign agency could have done an awareness for exhaust pollution, but that would have been much harder to do, and probably they won't make much friends while doing so. Where as something easy as a water saving campaign will give that loads of goodwill.
Or am I missing some sort of sarcasm joke?
If they're (hypothetically) a commercial driver, spending the day at work driving around in an 1980s diesel truck, or installing golf course sprinkler systems, they'd still feel that they're an environmentally responsible person.
If the ad campaigns instead of suggesting toothbrushing habits informed the public of the disproportionate pollution caused by old trucks or vilified inefficient agricultural watering practices, that person might have a 100x more effective impact from their personal obligation if they advocate replacement of the truck or change agricultural practices. Also, consumers of these polluters might help encourage change by, say, preferring a waste disposal company that uses newer trucks or by changing consumption to eat peanuts grown with rainwater instead of desert-grown aquifer-fed California almonds.
Realistically there could be a new initiative like that 1-5 times a decade. Society rarely behaves in the most optimal way, and as I said saving water is very low effort, though it might also be low impact. The real faillure not following up with more and better initiatives.
What if none of the available waste disposal companies are using newer trucks, are you supposed to call them every week like with congress people? And how is buying a bag of peanuts branded with some promise of ecological responsibility any different from saving water brushing their teeth? A single bag of peanuts from a different brand doesn't make any impact by it self and it only serves to make people feel like they've done their part adequately.
By analogy, if you were trying to help someone get out of debt, would you advocate they take unpaid time off work to walk along the roadside collecting cans for the deposit, or work overtime hours at $50/hr?
There's limited energy and funds available for these initiatives; by advocating ineffective ones more harm than good is done.
Goal is not to make a difference, it is to make you feel better for yourself.
So it really depends on the situation as well.