Manson did know that. He visited the house looking for Melcher and found Tate there.

Even though his initial visit was motivated by a dispute with Melcher, it’s pretty clear that Tate was the target.