I would make an analogy where the training data is like a textbook. If I read in a textbook about how to design/build a bridge, I don't have to give royalties to the textbook author when my civil engineering and construction firm gets paid to build a bridge. The copyright/license of the textbook can't prevent me from using the knowledge gained from the book to do a commercial job. In a similar vein, the knowledge gained from a public data set is probably fair game for whatever you want, just as long as you aren't repackaging the data itself. There's probably a good boundary requiring someone to stop at a point where the model weights can't be used to reconstruct the original data.
Of course, other people can disagree. I would look forward to an actual legal opinion to clear this up.
You're confusing this CC license with open source licenses that do not restrict use but require derived works to be created/distributed under certain conditions. This CC license restricts use, in that you are not allowed to use the data for any commercial purpose - this is totally different from open source, and more like the "academic use only" licenses which used to be more common.
I doubt that any company would be willing to take the risk of creating a commercial self-driving car using this data to get a head start. I don't think I'll be seeing this particular license fought over in court.
In this case, imagine a student working on a class assignment. They use this data for purely academic purposes with no commercial intent in mind. After they train their system, they realize yow I could use this trained system and get rich. There was arguably no commercial use during the training. The use of the data was purely academic, like a person learning math or French. What you do after running the learning is a separate matter, just as using a CC licensed textbook to learn math doesn't prevent you from getting a job as a statistician.
Again, the tl;dr is instead of trying to divine how a court will deal with a poorly specified problem, it's much better to just not license your stuff using a CC license. There are almost always much better licenses to choose from.
(With, I suppose, hints about what restrictions you might be wanting to grant or prohibit by particular license options?)
If that sounds like a crappy legal footing for the next 20 years of software development, yeah, it is. It's also why Mitch Kapor and a few others founded and funded the EFF to try to encourage better case law decisions around the early days of electronic privacy law. We definitely need an EFF like effort around ML/DNN/etc., but I'm not holding my breath.
I wish I had a better answer, I'm mostly hoping someone else here does.