As I got the super wallpaper functionality is available only for AOD devices (always-on-display - AMOLED powered smartphones).
BTW, for any other devices (like my lavender/Redmi Note 7 with IPS display) you can use them by installing themes as third-party apps and set via Google Wallpaper by...