More than likely your backup (.sparsebundle) is corrupted and you should take a fresh backup. In my situation, I had manually moved a Time Capsule backup to my QNAP. I verified this copy on the QNAP with Time Machine's verify and although it said it was OK, I could only successfully backup to it when the machine was logged in/active but never during powernap.
Regarding mounting SMB shares during powernap - that IS supported just fine on MacOS.
Assuming your NAS is named something containing "QNAP", if you run this terminal command you can see from the time machine log entries that it is clearly able to mount an SMB share (look for entries late at night when you are presumably sleeping and the machine is doing powernap wake ups):
log show --predicate 'subsystem == "com.apple.TimeMachine"' --info --last 24h | grep QNAP
...
2024-12-03 21:00:06.939364-0800 0x1d5f15 Info 0x0 329 0 backupd: (TimeMachine) [com.apple.TimeMachine:Mounting] Mounted 'smb://me@MyQNAP._smb._tcp.local/Backups' at '/Volumes/.timemachine/MyQNAP._smb._tcp.local/XXXXXXXXXXXX/Backup' (4.59 TB of 6.98 TB available)
If the backup is corrupted, you often see failed to mount in the logs during a powernap and a sprinkle of other random errors.
log show --predicate 'subsystem == "com.apple.TimeMachine"'
and see if anything stands out. Also and if possible, try backing up to a directly connected device to see if it works as expected.