Sirens are an Sx/So archetype. They lure somebody else (SX first) collectively (SO secondary) into abandoning their comfort zone or even shipwreck and death (SP last). You can see how mating SX in senseless overdrive becomes dangerous at the expense of SP, while there's nothing wrong with the social component. The siren's obsession with SX denies SP as in the song from the video clip. Financial support is not desired from the man - distinguishing the mermaid from the typical trope of sailor's prostitutes also - only sex and/or romance:
Combined with the eventual attack on the ship, SX desire and power of the sirens becomes the men's downfall.
In Germany we talk about the similar myth of "Loreley" often, a woman sitting on a cliff that gets the attention of sailors through her singing and charm - and they crash tragically because they didn't mind their course. There is an actual place where this cliff exists. The theory is of course that people had to invent a reason why this cliff created actual accidents, or maybe somebody misunderstood the name once - "Ley" originially meant rock, "Lore" means to peer. As the sailor peers at the rock, they do not notice the currents and curve of the river as you can see here, the Loreley cliff is on the right:
Coming up with an analogy of fatal female sexuality is convenient to the Sx/So theme, and since it has strong SO it is fairly known still.
I think we see 3w2 and 6w5 interacting here, Sexual 3w2 is deceptive-seductive, 6w5 troubleshoots with a rational mind that is not easily swayed, i.e. the only way to escape the siren chants. Odysseus is one of these 6w5s in mythology who defied the sirens thanks to his SP-secondary. I think his TIM is LIE. He acted quickly with the idea of stuffing the sailor's ears with wax, predicting the danger. He himself was motivated by a strong SX drive himself, wanting and thus long planning to see his wife again even after all those years (also: suggestive to

,

creative). It shows the long-term loyalty of 6 that deflects 3's temporary onslaught of charm.
Interestingly enough, Odysseus let others strap him to the mast so he could hear the chants but not move, likely out of sheer curiosity and thrill (SX) restricted by SP. Like that he would come to enjoy the chants but not the detriment of SP.
As with Loreley I see a covert theme here, this myth could be an analogy to infidelity and the sirens are a proxy for actual women now. It's quite a polarizing myth and comes to show how SX/SO creatures are quite a popular way in mythology to give metaphors to SP threats. In our examples here: the well-being of the sailors, Odysseus arriving safely in Ithaca.
Depictions that I became interested in recently and I still try to decipher culturally are those with a lesbian connotation. The meaning is ambiguous since we don't know if the waves are dangerous here, or it is the allure of the sirens themselves that could get the woman into trouble for whatever reason. Though I later saw the subtitle reads "Invitation into the Unknown" so it might be about trying something new in terms of sexuality:
L'appel des sirenes / Call of the Sirens - Burrel, 1915