You’re right Testing in that they were definitely intending for this saga to end with the death of the physical Skywalker bloodline and have it stand as a legacy for others to live by. But unfortunately most of them weren’t very good examples to look up to. We as the audience know this. Even Luke messed up pretty bad.
I feel like it all leaves a sour taste in your mouth at the end of the movie with the title The Rise of Skywalker. Yes, Rey picks up the name, but we all know that she isn’t a real Skywalker by blood. IMO, it is more of a positive ending for the Skywalker bloodline for Ben to learn from the mistakes of the past and be given another shot at creating a better galaxy.