Avoiding pronouncing the tetragrammaton of the name of God on the part of the Church has therefore its own grounds. Apart from a motive of a purely philogical order, there is also that of remaining faithful to the Church’s tradition, from the beginning, that the sacred tetragrammaton was never pronounced in the Christian context, nor translated into any of the languages into which the Bible was translated.
Fr Remaud is correct in the first link above in stating that respect for Jewish practice sheds some light on the directive. Not much is being written song-wise with the Name, not since the seventies, anyway. Most Catholic composers have avoided using the tetragrammaton for a generation, and for the reasons Fr Remaud expressed, not so much the CDWDS’s reasons.
Interesting, though, that through the Roman Rite gospel acclamation, we do proclaim a part of the name, Yah, as part of the Hallelu-Yah, or Alleluia. I suspect it would be much harder to set aside “Alleluia” for any time period much longer than forty days.