None of the CC licenses that I know of distinguish between marketing and other forms of use. The CC licenses have a range of restrictions depending on the specific one used. Freesound has a faq at https://www.freesound.org/help/faq/#licenses-0 The actual name of the license pretty much tells you what the restriction is though.

CC can be great for a lot of things. The biggest issue is that many people require attribution which can be tricky depending on the project. But there are some good options for CC that work well.