Make invalid output of ISRSrange_area() less likely, next try Since ST_MakeValid() might return a collection of lower-to-equal dimension geometries, distill only the polygons from it. This should prevent respective errors when trying to save the result to a column of type MultiPolygon.

INSERT INTO sys_admin.published_services (name)
   VALUES ('waterway.sounding_results_areas_geoserver'::regclass)
   ON CONFLICT (name) DO NOTHING;
INSERT INTO sys_admin.published_services (name)
   VALUES ('waterway.sounding_differences'::regclass)
   ON CONFLICT (name) DO NOTHING;