In Santorini, does my opponent win if I pull them onto a third level with the Siren?
No.

The win condition is stated as follows:


  If one of your Workers moves up on top of level 3 during your turn, you instantly win!


This doesn't happen in the scenario you described. Your opponent's Worker moved up on top of level 3, but it didn't happen on their turn.