CBD oil is used as a natural alternative to pain medications to reduce pain and increase relaxation. It won't directly help you sleep but it may help calm/relax you - which would indirectly help you sleep.
If you want a supplement that will help with sleep, check out the product n2sleep that the board sponsor n2bm.com makes -> https://www.evolutionary.org/n2sleep