Does Pay With Yat make transactions more private?

No, Pay With Yat simply acts as a lookup service that returns a crypto address associated with a specific Yat. The transaction’s privacy (or lack thereof) is fully dependent on the underlying blockchain's privacy functionality.