If we're going by "all species die out in the end" then anything we transition to will die too: entropy will get the whole universe in the end. Past that there'

If we're going by "all species die out in the end" then anything we transition to will die too: entropy will get the whole universe in the end. Past that there's nothing that says any species can't expand out, settle whatever planets they want and stick around to the end. I'm also pretty cool with my millions-of-years-from-now descendants looking back at me and thinking about how different they are from me. I would consider it an incredible success to go that long without catastrophically destroying ourselves.