Here is a clip on this that you may enjoy. It will help from the Reformed perspective.
Jesus’ lament shows us that human suffering, considered in itself, does not please the Almighty. Although God has ordained Jerusalem’s destruction, His revealed will in Scripture proves He has “no pleasure in the death of the wicked (
Ezek. 33:11). But, as John Calvin writes, “the will of God is exhibited to us in two ways,” and there is a sovereign will, unrevealed to us, that governs all that ever occurs (
Deut. 29:29). By this hidden will God may ordain events that by themselves do not please Him but nonetheless contribute to His glory, which is supremely pleasing to Him (
Isa. 48:9–11). God finds pleasure not in the suffering, but in the good He works for His glory through the suffering.
Ligonier Ministries, founded by R.C. Sproul, exists to proclaim, teach, and defend the holiness of God in all its fullness to as many people as possible.
learn.ligonier.org