You missed the single quotes around weather.installation in is_state().
However I don’t see why the number sensor is necessary. Just go straight to the binary sensor.
- binary_sensor:
- name: "Cloudy Weather"
unique_id: cloudy_weather
state: "{{ not is_state('weather.installation', 'Sunny') }}