What is the difference between normal Select query and a Select query inside Common Table Expression(CTE)?

Question

I'm having a table 'Products' and if Execute this query

SELECT TOP 1000 [ProductID]
      ,[ProductDesc]
      ,[ManufacturingDate]
      ,[ExpiryDate]
      ,[Price]
  FROM [TestSat].[dbo].[Products]

I got the output:

and If I use this select query:

SELECT ProductDesc,Price
  FROM [Products]
  WHERE Price>20.00

I got this output:

If I use CTE-Select like this:

 ;WITH ProductsCTE(ProdName,Price) AS
( SELECT ProductDesc,Price
  FROM [Products]
  WHERE Price>20.00
)

I got this output:

The only difference I found between this simple Select Query as well as CTE Select query is the Column name (ProductDesc as ProdName). Does it is the only difference between normal Select query as well as CTE Select query?