Bharatpedia:Substitution explains what happens when a template is substituted instead of transcluded.
The difference
Writing {{Example}} transcludes the template: the page shows its current content, and changes to the template appear everywhere. Writing {{subst:Example}} substitutes it: when you save, the template's current content is copied into the page as ordinary text, and later changes to the template do not affect it.
When substitution is required
- Welcome and warning messages on user talk pages are substituted, so the message a user received can never be changed afterwards by editing the template.
- Some maintenance templates say in their documentation that they must be substituted.
When not to substitute
Navigation boxes, infoboxes and citation templates are transcluded, so that one fix improves every page at once. Substituting them freezes old copies all over the site.