You can cancel a fully waitlisted counter/I ticket even after chart preparation/train departure at the counter. (Upto a prescribed time limit based upon distance factor)
For Online Tickets, a fully waitlisted ticket would be automatically cancelled and you would need to wait for the money to be refunded back to your account.