Syrian opposition = literally all Syrian factions other than the former government. Syrian Democratic Forces = US-backed Kurdish militant organization concerned with achieving Kurd autonomy. Not involved in the latest offensive AFAIK.
If I remember right they were involved, and there was some kind of agreement between the factions to not attack each other until the Assad regime was gone. So will have to see what happens now that the regime has collapsed.