It would probably lose on standing to sue. You’re absolutely correct that you can make the claim Sony’s Storefront sold you a game that did not work. But you did not buy it directly from CD ProjectRED, you bought from Sony who was licensed to sell it by the publisher.