Probably true for pen testers, forensics, or immediate response. I refer to architecture roles. I don't do on call anymore, my family comes first.

Ah yeah, that makes sense (as an aside, I am jealous and hope to get there someday). You'll almost certainly have on-call in ops, which is what OP seemed to be most interested in.

Secops people have on-call rotations. Pretty much nobody else does.