Why does any NPC besides the guide move into the houses I built?
Solution 1:
Simply build more houses and your Guide will eventually respawn. The game prioritizes spawning new NPCs rather than respawning dead ones, so there's nothing else you can do.