It refers to the death of a person or the end of something.
For example:
* The demise of the company was a surprise to everyone. (Here, "demise" refers to the end of the company.)
* His untimely demise shocked his friends and family. (Here, "demise" refers to the death of the person.)