Craigslist exists in France, and there is also leboncoin.fr.
Many of the French makers had tandems. You can look for an older Gitane or Motobecane in the low and mid price ranges, or go for a constructeur frame such as one made by Herse. I don’t know if more modern tandems could be available; my personal fascination is with old steel. :-)