At this speed community will make their own custom map/story faster than they can...
It's funny you mention this because that was literally the point of the devs focusing on Sandbox first and was explained by the devs in the official Discord and in the Patreon updates.
They prioritized Sandbox first so people could make their own content while the devs focused on the story. They did this so there wouldn't be long periods where we basically got nothing. Some people don't like Sandbox though so they're unhappy with where the game currently is.
Speaking of which, are there any custom maps/scenarios that have sex scenes done in the same way they were done in the old village demo (where you had to do few quests, the party, you know, the times when it was still A GAME with STORY)
You might be able to find some in the Wildlife Sanctum Discord or some in the official Discord sandbox sharing channel. Btw the current WIP missions require you to do short quests as well before getting to sex and whatnot. It isn't just talk to NPC then sexy time.
BUT actually like new animations made by community? Or are proper custom animations still not possible and only cheating them (importing animated models as objects and placing on the map in sandbox)?
You can make custom animations now. Can find guides in the official discord or the sanctum discord. AFAIK you still can't animate imported models though. I know Home Together which also uses UE5 started dabbling into mod support not too long ago and people there learned how to import characters into the game that can be animated/used for sex iirc, not sure if WL devs have looked into that.