[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

• [x] #3660
• [ ] refine drop catalog semantics and behavior
• [ ] refine drop metalake semantics and behavior
• [ ] support background async entity storage cleaner
• [ ] refine docs for drop metalake/catalog