Hey Douglas,
You are right — the examples does not make sense on their own. There is not reason to write with x as (select * from foo) select * from x where id < :n. I used this example to simply illustrate the effect of using CTE inappropriately.