Google's ad with the It Gets Better Project has irked some, but others argue its benefits can't be discounted.