@Be The Code As Consumption tier doesn't support VNET integration or hybrid connection so it would not be possible to call the non public endpoint from your consuption plan function. The endpoint should be publically accessible and it would not be possible to use Consumption function.
You would need a middle services that can send the status to the azure function (i.e. your custom code that is deployed on the same network where your non public endpoint exists and your custom service can send the status i.e. notification/message to eventgrid/servicebus so the function can be triggered) or deploy your own service that can directly communicate with the application insights to send the status.