The Anniversary Upgrade includes Creation Club content released on or prior to November 11, 2021 - like quests, dungeons, bosses, weapons, spells, and more. You must own Skyrim Special Edition to access this content.
For a full list of Creation Club content included read here (https://beth.games/3GzzeZS)