Is it possible to get node alias during hook_node_insert()
A couple of options there, if drupal_lookup_path isn't returning the alias yet.


Get the alias using pathauto_create_alias without the _pathauto_set_alias save part ( update: can use the 'return' option)
Add the node id to a cron queue defined with hook_cron_queue_info and get/process the alias in a worker_callback a little later.