Being on a cruise is supposed to be a luxury experience where you have no worries. That's how they're marketed. The failure here is that the OP's cabin was not useable and that should have been known at check in - the cabin attendant seemed to know this well before OP got there.

Regarding this needing to wait to see who shows up, it's a bit fishy. Cruises are not like airline flights, where they frequently oversell by a few seats. There isn't another 3000 passenger cruise ship leaving for cozumel in 4 hours to bump tohe oversells to. So, with 2 empty suites to give away as bingo prizes, plus at least one empty oceanview room on sailway day, good hotel management would have reassigned the OP to one of those rooms at check in rather than having OP roam the ship, find the unacceptable cabin, wait in another line at the pursers desk, etc.

Perhaps they bump premier guests to nicer rooms on sail day, maybe its first come first served amongst the elite, so maybe they were processing those movements before knowing exactly which mid range rooms were going to be empty. But they should have known OPs room was not useable, and told OP that at check in. A pass to a lounge, a free drink, and the eventual useable cabin would have prevented this thread from ever being started.