The only poison effect in the Rules As Written that knocks people out (and isn't just tons of mental ability score damage) is explicitly "Unconsciousness" rather than "Sleep" so that elves aren't immune to it - considering the primary poison that does that is Drow poison, and they like to use it on above-ground elves.
Calm Emotions explicitly allows affected creatures to defend themselves, so it definitely doesn't suppress survival instinct.