Essentially the apps have same package name but different signatures and the app store that installed it should be the only one to recognize and update it.
But Google is likely trying this dark pattern to sway people away from F-Droid or alt stores by making users uninstall these apps and install it from the Google Play Store.
It’s been going on for a while and is annoying af.
It’s because they are using like 10 disposable Google accounts shared between all the users in the world, so access is throttled
Aurora has been fine for me so far.
My experience might be better as I logged into the account of someone else to access some paid apps. Haven’t had much trouble with the disposable accounts either, may also because I haven’t used it that often.