While there is always a small chance of pregnancy if you have sex, it is very unlikely that you will get pregnant if you are taking the pill properly!
The pill (combined or progesterone only) is supposed to be taken at the same time every day to be most effective. If it is being taken correctly, the pill is 99% effective, or only 1 in 100 women will get pregnant. However, some people do miss a dose (which you should take as soon as you realize you missed it!), or do not take it at the same time every day. This typical use means that it is 91% effective, which is still very good at preventing pregnancy!
If you are concerned about having sex due to fear of pregnancy, despite the fact that you are taking your birth control pill at the same time every night, you should know that the risk is very low. It is also recommended that you use a condom as well as the pill, as this will be additional protection against pregnancy, and has the added benefit of preventing STI's! If you still do not feel comfortable having sex with these precautions, that's ok! Educating yourself is a great first step to help you understand what you are comfortable with for your body. Make sure you do what you are comfortable with, and have sex when you feel you are ready!