[Feature Request]: `operational-insights/workspace` - Refactor implementation of extension resources

[krbar]

Description

Align the implementation of extension resources like

• locks
• role assignments
• diagnostic settings
  and implementation of managed identities, with the new module design, using user-defined types.

[krbar]

Implemented via bulk PRs:

• [Modules] Updated locks to UDT as per AVM specs #4112
• [Modules] Migrated batch [4/4] to AVM RBAC #4132
• [Modules] Updated Diagnostic Settings to AVM Specs #4154
• [Modules] Updated identities to UDT as per AVM specs - Batch 1 #4124
• [Modules] Updated tags to AVM standard - Batch 3 #4161