[SPIKE] Refine `Exempt specific files from Codeowners rules`

Summary - Why is this spike needed?

Investigate potential solutions for Exempt specific files from Codeowners rules (#41914 - closed)

We are currently unsure of the details around this feature. We need to investigate how we can achieve this and create a proposal which should be added to the description in #41914 (closed)

Expected Outcomes

• Technical proposal added to Exempt specific files from Codeowners rules (#41914 - closed)
• Weight added to Exempt specific files from Codeowners rules (#41914 - closed)

Or

• Build the feature during this spike