Sounds familiar as I faced a bogey drop for several months. IMO a combination of mental and technical issues but the comforting things is that it is on a local trail and hence (I assume) has been ridden many times before. So probably (not wanting to insult your technical skills) predominantly a mental issue as sounds like “it can be ridden.”
Body position and dynamism I guess are understood. Have you done all of your braking before the drop, so that you can enter very slowly but then let go. Do you really need to brake if so? I was taught that on braking (if required) be gentle and release as soon as feel any wheel skid and then reapply very gently again etc….
I guess you are fully aware of where to look (the exit not the drop) but this is easier said than done when there is a mental block. IMO is you are not mentally committed you aren’t going to make it and all the advice in the world doesn’t help. You have to be comfortable in your technique, then fully committed….at which point it will suddenly become natural and easy and you will wonder what the fuss was about. IMO at least!
Good luck with it (and note that my comments relate to steep stuff on trails, not really hairy stuff!!)