nsfw refers specifically to nudity and gore. So as long as those two things don't appear in your game your good.
SFW Red Riding Hood Death:-
she lays there on the ground in a puddle of her own blood, her face is frozen in a pained expression, her body lifeless.
NSFW Red Riding Hood Death:-
a mess of guts and blood lays on the floor, severed pieces of legs and arms are scattered all around. And in the middle of it all is the severed head of the red riding hood.