ON DELETE CASCADE doesn't work even storage table is InnoDb
The CASCADE clause works in the opposite direction. From the parent to the child table.

When you delete a row in the parent table, the related rows in the child table are deleted as well.