Many, many years ago, when I did my very first night dive on Paradise Reef, I was nervous, thinking about the possibility that my lights would fail, that I'd lose track of the group, that I'd get swept out to sea by currents, that I'd end up the evening meal of a night-hunting shark. No such luck. I got used to the low light very quickly, and there was so much different to see that I very quickly lost all thought of anything going wrong. By the time I got back on the boat, I was ready to don another tank and di it again. A few years ago, I was with a group diving in Cozumel and paired up with a Newbie for his first night dive. He was also very nervous about diving in the dark, but I told him to relax, and by the time he came up, he admitted that it was by far the coolest dive he had done so far.
BTW, for my first several years of diving, every night dive I did, everyone in the group would tie a glow stick to the top of their tanks, and it was easy to keep track of everyone. But I understand (someone correct me if I'm wrong) that they no longer allow glow sticks in the Marine Park -- if the get loose or break or leak, that fluid is not very eco-friendly. I now have a small battery powered tank light that I use on Night dives, so others can track me, but on my last few night dives, no one else in the group had any tank lights - just the handheld lights. Check with your DM before buying any glowsticks. It was still pretty easy to keep track of the group, but I still like those battery powered lights that you tie to the top of your tank for keeping track of your dive buddy.