If sirens sing and lure people into water do the mermaids drown the people in stead of the sirens?

No, the sirens sing to sailors who pass by islands with cliffs and either they jump ship and drown unable to reach the sirens atop the cliffs, or a sailor might navigate the ship into the cliffs to reach them thus killing everyone.