The parasympathetic nervous system plays a crucial role in sexual function, enabling erection in men and lubrication in women. This system is activated by relaxation, while the sympathetic nervous system is responsible for ejaculation and is activated by arousal.