Document with_lock_retries and dropping a table

What does this MR do?

Update the docs regarding to DROP TABLE and add a section about with_lock_retries helper.

Screenshots

Does this MR meet the acceptance criteria?

Conformity

• Documentation (if required)
• Code review guidelines
• Database guides

Closes #34325 (closed)