Jesus wept over the city of Jerusalem and He wept when He saw people mourning the death of His friend Lazarus. He wasn't weeping because of the circumstances. He was weeping because of the unbelief of the people. His compassion was, and is, Heavenly. God sees the present and future complications of unbelief and it saddens Him.
When we lose someone or our nation is suffering under oppression it saddens us but there is a deeper root issue. God can take us under His wing. Death is not the end for those who trust that Christ is the resurrection. Will we trust Him? God has joy if we trust Him because He can work in different comforting ways If we trust Him