Currently, the UI only displays sync failure notifications. Airbyte will display the failure at the source/destination level in the list of sources/destinations, and in the connection detail page along with the logs.
Alternatively, you can configure a webhook to notify you on sync failure or success. The URL for the webhook can be accessed in the Notification Settings of the sync.