The Ko Olina resort area, of which Aulani is part, puts on a fireworks show over the lagoons at midnight NYE/NYD. There’s usually also music on the beach if you want to watch the show there. Last year, there was pouring rain but the fireworks still went on. We usually spend our holidays at Aulani, and the weather has historically been good during that week with only passing showers. In the before times, Aulani has set up a photo op with Stitch in the family activity room.
The entire island of Oahu takes NYE very seriously and you’ll see aerial fireworks popping off from locals in Kapolei all the way towards Waikiki. Several rooms, especially the island garden view that look inland towards the east will give you that kind of show from your balcony.
If you’re thinking about booking either 12/30 or 12/31, decide asap because the hotel fills up on those days with a sizeable number of local DVC members and guests booking a staycation over NYE/NYD. But I don’t think Aulani’s released hotel room availability beyond 12/30/22 yet.
Good luck and hauʻoli makahiki hou!