You can see the fireworks from the beach side of Old Port Royal.
I stayed CBR 2yrs ago.
Because my daughter was so young(2yrs old), we spent more time at hotel. CBR was very relaxing. Try to get some ice cream at OPR and sit down at the beach. Once fireworks starts, it is so nice.