For CCV and AUL, no. You can buy those points immediately.
For resorts not actively being sold, it depends on who you ask. Some guides say there are no waitlists, or that waitlists are closed (and proceed to steer you towards CCV and AUL). Other guides are believed to actively look for available points for their clients using their own waitlist. Of that subset of guides, some are pretty detailed (at least mine put up the appearance of due diligence and was consistent when I checked in), while others may be more loosey goosey and people have had more success nagging them regularly.
Most sold-out resorts will require a waitlist. Some are available immediately others will require more persistence on your part.