Ideas
(Hey, OP, make sure that there’s no source of noise in the room where your Sims are trying to sleep — like a radio playing dance music [Pop, Rock].)
I don’t have LS, but since it was released my Sims don’t go to sleep automatically after WooHooing. They used to queue Sleep after WooHoo every time, but now they WooHoo, then one of the Sims falls asleep normally while the other stays in bed, but there’s no Sleep action in their queue and they’ll get up autonomously in less than one IRL minute, unless I command them to sleep — in which case both them and their partner will wake up.
This happens every time with all my Sims in all households. (Playing on PlayStation 5, so mod free guaranteed — none of the affected Sims were downloaded from the gallery; it happens with new Sims made in CAS, premade townies and random townies.)
The single workaround I’ve found was to wait for the WooHoo to finish, wait a beat and then command the Sim who doesn’t have Sleep in their queue to sleep.