Rework get_site_root_overrides

[kalisp]

Is there an existing issue for this?

• I have searched the existing issues.

Please describe the feature you have in mind and explain what the current shortcomings are?

Currently SiteSyncAddon.get_site_root_overrides could raise Value error if it is called on non local sites.

How would you imagine the implementation of the feature?

It should be rethink and reworked to return only {}.

(ayon-core dirmap.py could be then cleaned up.)

Are there any labels you wish to add?

• I have added the relevant labels to the enhancement request.

Describe alternatives you've considered:

No response

Additional context:

No response