About half of Californians say polluted drinking water is not too serious of a threat to them and their families