I'm glad you like it! There are three endings for his route (SPOILERS): One where he comes back to help you but you don't chose to gain more affection through the remaining options, one where you get full affection and choose to listen to the Guide in the final timed choice of the route (that's the one where both of them fall into the lake), and one where you get full affection and chose not to the listen to the Guide during the final timed choice. The guide also has an ending that's sort of based around him in someone else's route. And it's only in that one ending that they both die.
Good luck! I hope you'll enjoy his other conclusions :]