I raised this question a while ago and the general concensus was that it does not work for morale, however if it does work I was led to believe that it only applies to the province where the Temple is. For, example if you have a temple of Mars in Rome giving +2 morale it will only apply to the units whilst they are in that province, hence almost impossible to check!