What it really comes down to is : Needed equipment for the task at hand.
A SCR is nothing more than a gas extender. It allows you to use a bottom mix, and not have to worry about po2 tox issues UNLESS you exceed your MOD. With twin hp 120's on your back, you could actually run out of scrubber duration and have a co2 breakthrough before you run out of gas (depending on depth). The scruber Limitations are based on your metabolic rate, and how much co2 you produce. Some folks can push a scrubber far, some cannot. The only worry is having a hypoxic mix in your loop, due to not enough "clean gas" being inserted on the constant feed. That is for me, the main reason that an o2 sensor should be on the unit. You need to know your po2, even if you won't tox, you can still pass out.
So in answer to your questions:
1: NO, SCR's have not reached the end of the line, nor should they. They are great tools.
2: CCR's are MORE APPROPRIATE in certain situations where carrying huge tanks is not optimal. They also allow you to go deeper and run your deco straight off the loop. Yes, SCR's can do that too, but they need other gear (Tanks, travel gas, etc...)
3: Do CCR's have more failure points than SCR's... Yes. Does the task outweigh the risk? Depends on the task. In some explorations, CCR is the only way to go. Alot of sites do not have picnic tables, drive up lanes, a sandwich shop, and a compressor.
IMHO, SCR's and CCR's both have their place. Some archaeological sites that I have been to WILL NOT ALLOW bubbles below the anoxic halocline. If you need to do that job, you need a CCR. For long duration, task loaded big cave exploration, a SCR is perfect. When I want lobster, I use an AL80. Just match the equipment to the job at hand.
Cheers
Though the reply in its totality may not be DIR it contains good information concerning the original post, and why CCR's are a riskier choice, without benefit. Especially convincing is the fact that with a decent sac one can run out of scrubber before they run out of gas. If a CCR is going to be more efficient with the gas, but the scrubber still only gives you six hours, what good is the extra gas? You just get a poop-load of complications in trade. Or did I miss something?