It's the game developer's responsibility to respect the artist's license. If they purchase an asset, they acknowledge any restrictions, such as prohibitions on NSFW content. If they fail to read the license beforehand, they may be eligible for a refund.