Should I be scared?

Destiny
Tbh having sex for the first time scared the shit out of me. I'm afraid of the pain and the embarrassment and the bleeding. Is that weird? Any advice to help me not be scared? 
​Also is it weird that I want my first time to be with my best friend? ( who I happen to be madly in love with?)