[EPIC] Unify drop metalake and catalog behavior

[mchades]

Describe the proposal

metalake and catalog are completely managed by Gravitino, we need to clarify the drop semantics and behavior for metalake/catalog.

This issues is uesed to track relatived tasks

Task list

• [Improvement] clarify the semantics of drop metalake and catalog #3660
• [Subtask] refine drop catalog semantics and behavior #5066
• [Subtask] refine drop metalake semantics and behavior #5154
• support background async entity storage cleaner
• refine docs for drop metalake/catalog