Errors are generally caused by the network as a whole. NOT CCC.
A regular reboot of the entire network is a necessity under more recent versions of Mac OS.
Your error is clear..
ie the sharepoint is not mounting.
This is bound to happen when you do not use local backup drive.
All you need to do is ensure the backup is mounted in finder. Mac OS of late has loads of issues if whatever you use as main router is not so bonjour aware.
I have to admit after 50 posts I am somewhat lost in your setup and changes. If you have issues
Please.. please
Give a careful and full description of your network as it exists now. Give us make and model of all the different items. And show screenshots hopefully with their IP addresses.
Some aspects of a network can be improved.. but in the end.. finding local resources depends on bonjour working.. as soon as you move away from Apple routers you must do a bit more work to keep the network updated in the OS.. eg the weekly reboots.
As a BTW.. and follow up.. since I did recommend you used the Asus as network backup device.. I have been experimenting. (I know you moved immediately from Asus to Netgear Orbi.. so lost the use of the Asus.. )
Some care needs to be taken with what USB drive you use.. my first attempt was using one of my Toshiba/HGST Touro desktop drives.. but the result was really poor. I think the way Touro handles data is slightly different and Time Machine would discover the backup was corrupt every time even though the previous backup was successful.
I changed to a simple self powered 2.5" drive.. and that has now been working great.
I plugged the Touro into the local computer and it has no issues.. so it was only over the network the issue existed.
The backup on the Asus has been running a few days.. since 8th Dec.. and is giving me no issues at all.
What is nice is the Asus log gives me complete details of each backup.
Dec 13 14:34:03 afpd[17791]: AFP3.3 Login by admin
Dec 13 14:35:35 afpd[17791]: AFP logout by admin
Dec 13 14:35:35 afpd[17791]: AFP statistics: 115855.33 KB read, 275563.77 KB written
Dec 13 14:35:35 afpd[17791]: done
Dec 13 15:34:05 afpd[24929]: AFP3.3 Login by admin
Dec 13 15:36:37 afpd[24929]: AFP logout by admin
Dec 13 15:36:37 afpd[24929]: AFP statistics: 203544.57 KB read, 336323.43 KB written
Dec 13 15:36:37 afpd[24929]: done
Dec 13 16:36:33 afpd[32553]: AFP3.3 Login by admin
Dec 13 16:38:54 afpd[32553]: AFP logout by admin
Dec 13 16:38:54 afpd[32553]: AFP statistics: 252926.83 KB read, 343025.20 KB written
Dec 13 16:38:54 afpd[32553]: done
Dec 13 17:39:14 afpd[7436]: AFP3.3 Login by admin
Dec 13 17:41:22 afpd[7436]: AFP logout by admin
Dec 13 17:41:22 afpd[7436]: AFP statistics: 168125.19 KB read, 264008.84 KB written
Dec 13 17:41:22 afpd[7436]: done
Dec 14 06:01:17 afpd[27847]: AFP3.3 Login by admin
Dec 14 06:03:53 afpd[27847]: AFP logout by admin
Dec 14 06:03:53 afpd[27847]: AFP statistics: 310509.77 KB read, 334975.34 KB written
Dec 14 06:03:53 afpd[27847]: done
Dec 14 07:01:15 afpd[2297]: AFP3.3 Login by admin