Aurora isn't an alternative app store, it's an alternative method of accessing the Google Play Store. F-Droid is an alternative app store on Android usually used by degoogled phones.
With alternative stores, I'm hoping that we'll get a choice in where to install public transport apps, Spotify, Discord, games, et cetera from, rather than having the choice between Google and illegal mirroring sites (the app's owner holds copyright and didn't authorise something like apkmirror/apkpure to distribute with ads and potential malware, though they've proven more reliable on the latter front than early apk redistribution sites).
That's how I also read GP's comment, but your reading is also a valid one.
Correct and I do get most of my apps from f-droid but unfortunately majority of big apps (banks, IMs) are on Google play only... because there is no sane/official alternative now (even f-droid can't update the apps automatically... )