Lower-than-expected support for proposition comes as multiple California cities looked set to oust progressive district attorneys