Does this private relay work only for safari traffic leaving the device?

Yes only in Safari

From the url you posted from:

Learn how iCloud Private Relay—part of an iCloud+ subscription—helps protect your privacy when you browse the web in Safari.

But it also applies to anything coming back in. Like a request from a website, the return data is also protected through private relay.