I think something like this may work:
=(HoursWorked + IF(AND(Worker = "CW", Date <> Christmas, Date <> Holiday), NightHours * 0.5, 0)) * IF(Worker <> CW, 1, IF(Date = Christmas, 2, IF(Date = Holiday, 1.5, 1))) * BasePay
First IF, adjustment for night shift hours
If the person is a "CW" and it's not Christmas and it's not a holiday, then add half the night shift hours to the total hours worked. That gives you time-and-a-half for the non-Christmas, non-Holiday premium hours.
Second IF, check eligibility for overtime
If the person is not a "CW", the base pay multiplier is 1.
Third IF, check for Christmas
The person is a "CW".
If it's Christmas, multiply the base pay by 2.
Fourth IF, check for holiday
The person is a "CW". It is not Christmas.
If it's a holiday then multiply the base pay by 1.5.
Else, no overtime
The person is a "CW". It is not Christmas. It is not a holiday.
The base pay multiplier is 1.