The reason that nothing is being deleted from the Employee_Test_Audit is because @empid is null. You are querying the virtual INSERTED table whilst in a DELETE trigger... change
select @empid=i.Emp_ID from inserted i;
to
select @empid=i.EmpID from deleted i;