A long-awaited coalition deal is finally signed, but many are critical and few are confident it will do much more than keep Netanyahu in power