The Content Pyramid concept from the Snow Leopard book outlines five levels where 90% consume content, 9% curate it, and 1% create it. The levels progress from consumption to curation, obvious connection, non-obvious connection, and finally, category creation. Each level reflects different levels of engagement and insight sharing, highlighting the importance and impact of making non-obvious connections in content consumption.