Welcome to the community, @Courtney_Smith!
It sounds like you don’t need to delete any records, but you just want to clear out your “linked record” field after the task changes its status.
That would be possible with Airtable’s automations feature.
Set your trigger however you would like. Then, for your “update record” action, add your “linked record” field — but leave the field completely blank. That will clear out the field.