Major Dune spoilers:

Isn’t that pretty explicit in Children? Leto II frequently chastises his genetic memory father/actual father for being a coward to afraid to commit to the golden path. Paul saw where the golden path led and couldn’t do it so he becomes the Preacher whereas Leto saw what was needed to guide humanity and thus sacrificed his to become The Tyrant