A major police probe has been launched after a man found injured on a footpath in Sydney’s south died.