Hi Mahfuzrupok-2233,
This feature guarantees that SPNs are unique in a forest, which prevents computers and domain controllers from adding duplicate SPNs. You can read how to disable it here:
https://support.microsoft.com/en-us/topic/kb5008382-verification-of-uniqueness-for-user-principal-name-service-principal-name-and-the-service-principal-name-alias-cve-2021-42282-4651b175-290c-4e59-8fcb-e4e5cd0cdb29
The answer to your question is that there would be no detrimental affect as long as there are no duplicate SPNs. If you have undetected duplicate SPNs, they can cause issues, including Kerberos authentication problems or application failures. However, there are some situations/tools that require the ability to bypass the duplicate SPN check in order to function properly.
If this is a temporary measure to allow a third party app to install or operate, I would recommend returning the Alias Uniqueness Check once finished.
--If the reply is helpful, please Upvote and Accept as answer--