I think the new cabins will have an excellent view of the fireworks, as will the entire North wing rooms of WL that face MK. You can see on this aerial view that the view is pretty much unobstructed:
View attachment 263107
It appears that the closer to World Drive that you get, the better the view of the fireworks.
EWP takes place in Bay Lake and will probably not be viewable by the same cabins.