Is it correct to say that's where my heart lies?

Yes, it's fine.

That = demonstrative pronoun

is = linking verb

where my heart lies = noun clause

It's quite unusual to see "That" used to represent a place, but I suspect it is being used figuratively.