Hemp oil is often industrial grade from China, containing loads of pesticides. Buyer beware as it is a lucrative market.
As a periodic sufferer of night terrors myself, I wouldn't put all my stock into cannabis, though it can be helpful.
It's not a cure all though. Gentle yoga, breathing...