You can only query data with Overpass, that also exists as such in the OSM database. As there are no existing OSM relations in the database covering the area between roads, you cannot query such data via Overpass in this specific location.

The following query will return any ways with tags, that are not in the list of tags you wanted to be excluded:

[out:json];

(way[~"."~"."]({{bbox}}); - 
(

  way["natural"="water"]({{bbox}});
  way["natural"="water"]({{bbox}});
  way["water"="lake"]({{bbox}});
  way["natural"="coastline"]({{bbox}});
  way["waterway"="riverbank"]({{bbox}});
      
way["highway"~"primary|secondary|tertiary|residential|unclassified|service"]["sidewalk"!~"."]({{bbox}});

););


out body;
>;
out skel qt;

http://overpass-turbo.eu/s/j3P