Most of the fireworks are shot from the main site. The flares near the castle are high enough to see from the lagoon, and the projections on the castle (which will be difficult to make out at best) are really inconsequential.
The further away you get from the castle (while still being able to see the castle), the better your view of the whole show.
Enjoy the fireworks cruise.