This is the trickiest part for non-Steam users. You cannot download directly from Steam Workshop without owning the game on Steam. However, there are three primary sources.
Even without the Workshop, the most transformative "new" and "essential" content remains accessible through manual downloads: the binding of isaac repentance mods no steam new