Remove waiting users memberships

We'll use the `:waiting_user` role instead.

![](http://www.lovethispic.com/uploaded_images/9765-Lighter-Flame.gif)