Verification from Foreman/Katello that both products are supported on CentOS Stream

This is not the case. You may have been confusing Katello and katello-agent? Please see my response here:

In any case, Foreman and Katello are intertwined and have no plans to end support for RHEL or CentOS going forward.

Side note: Foreman & Katello are upstream open source projects, not companies. So there aren’t any Foreman or Katello “employees” per se. Many of us work for Red Hat but some for other companies. Foreman, Katello, and other plugins are packaged downstream and turned into products such as Red Hat Satellite and Orcharhino.