Concerning the question
-Did any contemporaries actually take note of the ruling?
Like any ruling, some did, some didn't. From an article at MilitaryHistoryNow (emphasis mine):
But while the church frowned on Christian-on-Christian use of the crossbow, religious authorities of the day had no problem when the weapons were being pointed at non-believers, heretics and heathens. As such, the weapons featured prominently in Crusader armies. Yet back in Europe, they were controversial. Both the Holy Roman Emperor Conrad III and the Kingdom of Flanders abided by the holy ban in European wars and sent their own crossbow men packing; other continental powers skirted the rules when they could. But even with their prohibition, crossbows continued to be widely used.
Another source, International Encyclopedia of Military History edited by James C. Bradford confirms that Conrad III, Holy Roman Emperor from 1138-1152,
condemned their use in his domains
Conrad II is also mentioned in an article which appeared in The Nation, (in 1961), entitled 'UNILATERAL DISARMAMENT: 1139 A.D. - - by Jack Rothman',
"So, moved by humane considerations, the Lateran Council, which advised the Pope on secular affairs, in 1139 declared the crossbow 'a weapon hateful to God.' The ban was observed unilaterally by Conrad III of Germany, who forbade its use in his armies for thirteen years, meanwhile trying to persuade other powers to do likewise. He failed, and by 1152 Conrad's soldiers were again using the crossbow."
So it appears that Conrad only was able to uphold this ban for 13 years, and then resumed using the crossbows as well. No information here concerning the inclusion or not of long bows, and this article seems to also interpret the papal ruling as mainly directed at crossbows.
The same source mentions that the Magna Carta in 1215 banned the use of crossbows specifically.
So some did observe the ruling (which was in in April 1139), though for only a limited time, while others 'skirted the rules'.