It depends on how “not really explicit” the lyrics are, both in intent of the author and in how the singer hears them.
For example… when I first heard a bit of the song “Making Whoopie”, I was a kid and the song was being used in a commercial. The catchiness of the song was all I recognized. In later life, when I heard the whole song and had a bit more background, it became a bit more embarrassing! You’re probably the best judge of whether a song is “turning you on”, or just a bunch of syllables. If the song’s in Romanian, you don’t have Romanian neighbors, and you have no clue that it’s talking dirty, it’s probably not going to affect you negatively unless it’s got a sexually charged tune and arrangement.
The other question is whether the song is actually aimed at inciting lust, love, or simply being humorous or catchy. Again, your prudence is probably able to determine this.
But if a song is full of cusswords in your own language, or calls people something horribly nasty; or if you find out that the song in another language or slang is saying something nasty – well, it’s probably best not to sing it. (Especially if other people also know that’s what it says, even if they don’t speak the language.)
For example, that “Lady Marmelade” song is very catchy, but is actually not about a particularly nice subject and contains an obscene proposal in French. Oops – especially since lots of people know that’s what it’s about. Sometimes I find myself singing it when it comes into my head. I don’t beat myself up about it; but I stop singing it. It’s not even vaguely appropriate.
OTOH, “The House of the Rising Sun” treats of much the same subject, but as a dreadful warning “not to do what I have done” – and most people don’t even know what the heck it’s about, so it’s hardly likely to offend or excite them. You wouldn’t sing it in church, obviously; but it’s probably okay to sing it in most times and places, except in front of little kids who might ask you what it’s about.
