No, that’s only the case for non commercial licenses.
CC0 (nearly public domain), CC BY (attribution required), CC BY-SA (also derivative work has to be put under the same license) and CC BY-ND (no derivates allowed) can be used commercially without any issues. It maybe can be difficult to make money with something derived from CC BY-SA, because everybody can redistribute that for free, but it doesn’t ban it. For the other three modifications can be licensed differently. Derivative work also rather means derived assets and not a full game.







