Does The end of a narrative usually resolve conflict and plot tension?

Usually. It's suppose to. However there a lot of experimental fiction out there that plays around with this rule.