As far as we know, there is currently no automatic notification when a user submits a Content Request in Content Catalog.
If this feature is added, it would greatly improve the admin experience by making content request management more efficient and ensuring requests are not missed.