Whether you automate pihole upgrades is separate from whether you automate debian package updates. I recommend at least automatically installing security updates for the OS, unless you want to manually keep track and do this for all your devices.