Cruise ship tap water in your stateroom is perfectly safe to drink. It likely won't be as cold as the water you'd get in the restaurants or from the dispensers around the ship, and since it isn't filtered as heavily it may not taste the same, but there's nothing wrong with it.