In order to have AVIF support in digiKam on Debian, you need to install kimageformat-plugins.
$ sudo apt install qt5-avif-image-plugin kimageformat-plugins
Alternatively, similar support is offered via qt5-avif-image-plugin, but Debian recommends kimageformat-plugins for general users.