We have sales asking for this all the time - not just for sales insight emails. Our workaround is to add a "send alert" flow step in the "email send" smart campaign. It's basically the same as "send email" flow step, but allows us to hard code or tokenize who the email should be sent to during every send. In our case, we use a token {{lead.SalesBDE email address}}