Are the Shore Excursion discounts for everyone on the reservation given to the guest in the stateroom with the highest tier?

No. The amount of the Shore Excursion discount is determined by the Latitudes Rewards tier level of each guest. Each person in a stateroom must present their keycard to receive the discount commensurate with their tier level.

See ncl.com/latitudes-rewards-program for tier discount breakdown