The church has changed the wording and no longer calls it extreme unction. Rather it is called anointing of the sick to more accurately show and demonstrate the power of the sacrament. The sacrament of the dying is call viaticum, because one is on the way to their eternal reward. Because for centuries this sacrament was administered at the point of death it received the previous name.
Many parishes have anointing services throughout the year.
It is meant to be a sacrament to restore one's health and lift them up in Christ, uniting them with his sufferings.