Would switching all my mods from the Steam Workshop to Nexus affect my current saves?
No. It's just a different way of downloading the files.
You might have problems with different versions of mods, but those should usually be minor.
But as always: Back up your saves.