Aggregate the introspected supported_collections across all catalogs into
a flat list of “collection -> serving catalogs.” Catalogs whose
supported_collections is None (not yet introspected) contribute nothing.
Return the IDs of every catalog whose introspected set contains
collection_id. Catalogs with None (uninitialized) are excluded — we
only report definite matches.
Return the requested collections that no known-introspected catalog can
serve. Conservative: if any catalog has unknown (None) capabilities, we
don’t flag the collection (it might be served).