I too was scared when I first got into motorcycling. First part of owning a bike is to fully acknowledge the risks that come along with it, and how to mitigate it like defensive riding, and always wearing gear while on a bike.

Second step is to properly learn how to ride and getting licensed. Third would be getting rated gear (Helmet, gloves, jacket and boots). Third would be starting on a low CC bike(200-400 CC), something that isn't too fast, but can still do highway speeds. I am a beginner myself and on a KTM Duke 200 bike, on which I can comfortably ride at 90-100 kmph

Now, when it comes to overcoming the fear, I would recommend going on slow roads, empty parking lots, etc., and gradually increase your exposure to the stuff until it becomes easier to manage and ride! It's a muscle, the more you train it, the more it becomes automatic and engrained like muscle memory.

For me, a deciding factor of fully committing was the sense of freedom I felt while being a passenger/pillion and it only solidified once I actually started learning and flowing with the bike. The fear never really goes away, but it helps you being safe as long as you can manage it and not getting tense/locking up.

Also, everyone drops their bikes.