How can I destroy an actor while overlapping with a collision box?

You can’t do it this way.
You need to put the entry in your own character’s BP.

You can use the images below if there is more than one enemy.

Character BP

Enemy BP