The way I understand it...
Consumption in the form of a slow burning pipe is more likely to be a relaxant, but nicotine absorbed in faster ways (cigarette, chew, snuff etc) can be a stimulant.
Or your pipe can be a stimulant too, if you are smoking nicotine heavy blends, or back to back...