'Succession' creator decided to end the show despite HBO being hungry for more