The only concrete usage example is on the deepmac.org home page where it says: For example, a CISCO device with a MAC prefix assigned in the 1990’s is more than likely an elderly model. OK, if I'm connecting to an ancient CISCO device, I suppose it might be handy to know that it might not support the latest protocols or might need updating.
But I think tracking people and network surveillance are the more likely uses. You connected with MAC address 3c:45:a3:6a:0d:76 at the coffee shop? That tells us that you were using an HP laptop manufactured in the October to November 2014 timeframe.
This database will be especially nice for finding people who spoofed their MAC address, and therefore deserve extra scrutiny. You used an impossible (never issued) MAC of ef:22:7b:09:09:ba to connect to the Internet. Or the MAC was issued in 1999 and it's unlikely that you're still using such an old laptop. Why are you changing your MAC address? We need to investigate you.
Maybe we can use this database "in reverse" to make sure all spoofed MAC addresses look real.