A person who is unwilling participate in what he perceives to be risky, embarrassing, dangerous or foolhardy activities; the term is usually used to denigrate such individuals by those who do participate in the same activities.
Similar usage sometimes to 'coward', 'sissy' or 'momma's boy'.