I found out what's missing from your "/tmp" filesystem entry: you need to set the 'needed-for-boot?' field to #t.
I don't think the above counts as a user error, rather it is a workaround since x11-socket-directory-service relies on activation-service-type which does not take 'file-systems' service into account. Cheers, Bruno