It fell apart in the Capaldi era. The "kill the moon" was the "jump the shark" of neu-Who
Implying it hadn't already fell apart in the Matt Smith era, where there was a season finale that made less sense than the end of Neo Genesis Evangelion (I think I'm talking about The Pandorica Opens, but it's honestly all a blur, and was at the time I watched it too). Moffat hyped up future episodes but could rarely deliver, RTD just hit you with a massive sucker punch on the 2nd or 3rd last episode and WOW.
Also implying that the wheels weren't kinda getting loose when 10ant said his final farewell at that (otherwise fairly underrated IMO) episode where the Master was hungry.
Capaldi had strong episodes throughout his run, but yes, I personally did dislike some of the storylines. The Zygon stuff felt very weak to me, and I never understood the "The Hybrid" storyline. But heaven sent/hell bent were bangers, and I definitely enjoyed his finale Cybermen episodes.
But yes, the moon suddenly reappearing in between shots, perfectly fine and identical to before, was very silly