> In dune there is a story part were the ruler knows what he needs to do but also realizes that he is not strong enough and knows that his son has to fullfil it (I forgot what it is about)

I think you're referring to the Golden Path [0]

[0] https://dune.fandom.com/wiki/The_Golden_Path