I dropped a night today that did not immediately re-appear. It is possible that someone else was looking for it just then, but who knows?
Whether the waitlist is running or not, there is still the chance that one of the other hundreds of thousands of members is looking for what you are cancelling while you are cancelling it. Personally, I would never cancel something that I wasn't willing to lose completely.