Coffee creamer is bizarre. It makes everything you add it to taste sweet, oily and industrial yet it's so popular in some cultures that it's considered a no-brainer.
Well, there are over 5 billion lactose intolerant people out there. Coffee creamers do typically include a very small amount of milk derivative, but it's not enough to make a difference if you don't have a dairy allergy.
It tends to be geographic, so if you live in a region that's able to deal with lactose, you'd have the impression lactose intolerance isn't super common. But entire regions are lactose intolerant, like Southeast Asia (including China) and about half of India.
Basically anytime you see dairy as rare or non-existent in a region's traditional cuisine, that's why.
I think a good approach is to only use it as a light sweetener, I only pour about 5g-10g of creamer into my lattes. Coffee mate's Hazelnut creamer is the only flavour I tolerate, the rest taste too synthetic.
I use like less than a tbsp of coffee creamer for coffee.
The flavour is so artificial that any more will make me feel sick. It just tastes like soap.
Many coffee creamers also taste terrible, I'm very surprised at the popularity of them overall.
I get a specific kind that I can bear and I put a very small amount and it works for me. I don't like milk. Black coffee is okay but I do like it with creamer more.