The author did mention that he was mainly using this story as a way to work out how he himself felt about Sakuya becoming a vampire, so the sense that it doesn't go anywhere might just be a result of that.
I do think the end is well-written, though. Sakuya's lifelessness and Marisa's unchanging nature (I thought it was a nice touch how the stuff she mentioned in the first doujin was carried on here) contrast very obviously with Reimu's awareness of the transience, and thus the beauty, of each day.