You are using a static recordset inside the loop, you have not set the recordset to use the value from the first query.
If you revisit the tutorial, you will see that the second query has is set to filter using one of the columns from the first query, on your page, you are just using a completely static recordset:
SELECT ContentID, ContentDate, ContentRefID, ContentValue, ContentPageSetOrder FROM pcms2_contents WHERE ContentRefID = 'BlogPostTitle' AND ContentPageSetOrder > 0 ORDER BY ContentPageSetOrder DESC