After Insert Trigger never fires using Import Wizard
The SQL Server Import and Export Wizard does not expose a way to enable triggers directly.

You could save the result as an SSIS package, then edit that to enable the FIRE_TRIGGERS option in the component it uses.

Alternatively, and probably more simply, you could choose to use one of the other data import methods that more easily allow you to specify that triggers should be fired.

Related official documentation:

Bulk Import and Export of Data (SQL Server)
Controlling Trigger Execution When Bulk Importing Data