The musician eventually found “peace” on the stand at Sean Combs’ trial because he wanted to support Cassie after her “nightmare”