jackie_w & theducks have the right of it. See our FAQ
Can I use both CC and calibre's USB connection at the same time?.
If you really want to sideload books using USB then using CC' Cloud's "Local Library" option might work for you. See
I have a copy of a calibre library on an SD card. Can CC use it?