For the body? Death is the end for certain. But if you believe that consciousness is not manufactured by the body, then it's not really the end for "you".
Some people believe in a single universal consciousness. Like a signal that transmitted and received by almost everything. Sort of like how radios and TVs receive and process signals in different ways.
Now imagine the human body as the most incredible piece of equipment. We receive the consciousness signal and it operates through us in seemingly limitless ways. We have a brain that records experiences, processes information, stores memories, builds ideas.
In essence, we are not our brain, it's just something we use and operate through.
Without consciousness, the signal, running through us, we are essentially a car without a driver. A game without any active players.
Our body is destroyed, the same signal continues, but it is no longer received by our bodily vessel.
Why would consciousness want to operate through us?
One idea is that consciousness exists in a different dimension to the physical world our bodies exist in. Operating through us is a way to experience something a new dimension, perhaps to learn, entertainment or because why not? The physical world could be one big playground for consciousness, almost like an open sandbox video game.
Let's say you're playing a video game, running levels, acquiring stats, experiences, leveling up, items. You the player are not actually the character saved on the hardware, when they die or are deleted you still exist don't you? You simply start a new game, load a new profile or whatever.
Perhaps switching to another video game or games console could be compared to consciousness living through a different animal, organism or anything, with different rules, senses and ways to play the game.
Food for thought