Quoting Commentary for I Chronicles 28:3

The Yalkut writes concerning the verse “You will not build a house for My name, for you are a man of battles and have shed blood” [I Chronicles, 28:3]. When David heard from the Holy One that he should not build the Temple because he had killed many gentiles and shed much blood, David was very frightened. The Holy One said, do not be afraid. The gentiles are considered by Me as if you had brought sacrifices. David said: why should I not build the Temple? The Holy One said: if you would build the Temple, then it would remain standing forever and would not be destroyed. David responded: let it remain standing forever. The Holy One responded: I know very well that Israel will commit sins and I will destroy the house. Israel is protected in that I will not destroy them completely. That is to say, the Temple is an expiation for Israel. They will see the great destruction and they will be very troubled, as if they themselves would be destroyed. The Holy One said to David: because you wanted to build the Temple, I will consider it as if you built it yourself and I will call the Temple after your name, as the verse says, “A song for the dedication of the House of David” [Psalms, 30:1].¹⁵Yalkut Shimoni, II Samuel, Remez, 145.