As discussed in the aerc-discuss mailing list, aerc seems not to be capable of deleting messages on notmuch queries, even when it can move or archive them.
As mentioned in aerc-discuss, this is by design of notmuch: https://notmuchmail.org/excluding/
~inwit but this is actually notmuch+maildir so we should be able to delete