GI1
There are a few requirements for unattended updates. Apps can only do unattended updates on apps that they are the "installer of record" for, meaning that they have installed or previously updated this app as well. If you are trying to update apps with the Play Store that you have installed from another source, this will require a confirmation prompt. Once you have updated an app once with Play Store, any successive updates should be able to go unattended.
GI1 just tried the Play app again
This wording seems to imply that you are usually not using the Play Store. If this is the case, this might be the reason why you are getting the confirmation prompt.
As a reminder, Aurora Store is not recommended and for normal usage¹ with apps from the Play Store, you should only use the official Play Store with sandboxed Play Services.
¹ Excluding some niche special use cases like bypassing Play Integrity on app-listings. Otherwise see my previous message.