Update diagrams in the context of RDBMS support and secondary storage

[hisImminence]

With RDBMS support, we need to update the images related to:

• RDBMS support for orchestration cluster
• Optimize relying still on ES/ OS (shown as a separate database connection)
  as aligned here.

With this ticket we should go through all the diagrams in SM and make sure they represent 🔝 consistently.

Diagrams can be found in InfraEx - Collection of Diagrams.

This task in on hold until #8392 is merged to avoid conflicts.