Just because a room is available for sale doesn’t mean a member requesting a Suite Night Award will be upgraded to it if Marriott forecasts that the room will be sold.
A room can be available 24 hours prior to check-in, but Marriott’s systems will still hold back the inventory to possibly sell to someone rather than upgrade the member into that room.