NICU offer

Hi ! I am a new grad who has been offered a position in the NICU at my dream hospital. It is a level IV NICU and part of me is terrified to accept the job because I am terrified of failure and not being able to progress at the rate I am expected to. I really want this but I am so worried as this will technically be my 2nd new grad position as I was let go from my 1st one due to failure of not progressing (it was in a different hospital and unit). I'm hoping my passion and drive will be enough to get me through this but I can't help but to constantly doubt myself; my self-esteem has been pretty low since things went sour with my last position. I suppose I am wondering if I will be a great NICU nurse or if I even have what it takes. I am ready to completely dedicate myself to this position in order to be a great NICU nurse, but simply put - I don't want to fall flat on my face again. Mentally I don't think I can handle any more disappointments...