Revert "Merge branch '587379-prioritize-foundational-chat-agents' into 'master'"

What does this MR do and why?

This reverts merge request !225264 (merged) because it appears to have introduced a master:broken.

See gitlab-org/quality/engineering-productivity/master-broken-incidents#22397 (closed). bundle exec rspec ee/spec/finders/ai/catalog/item_consumers_finder_spec.rb fails now.