For those that have landed here while trying to solve the same problem for MySQL, the INSERT statement has to go before the CTE:

-- MySQL code! Not SQL Server
INSERT INTO tablea(a,b)
WITH alias AS
(
    SELECT y,z FROM tableb
)
SELECT y, z 
FROM alias