TL;DR: It works for my specific needs if used with caution. It is an active treatment, not a moisturizer. Avoid sensitive areas. But you need to understand that the causes of texture and inflammation can very very different. Look at your skin closer than you look at strangers' reviews. Go to acne.org if you haven't.
Here's my context:
I have normal/dehydrated skin prone to inflammation and hyperpigmentation. At this point I'm used to being covered with dark spots the tenacity of which surprises even aestheticians. The outer layer of my skin is also very strong despite being thin and transparent (I realized I have to leave AHA longer that recommended for it to work, then I tried Derma E glycolic toner to add daily AHA and literally felt nothing, etc etc). I think I figured out my hormonal breakouts - adding extra zinc and iodine supplements on top of a good multivitamin with resveratrol really cleared those painful red bumps that leave dark spots behind. I was so happy because all I was getting reduced to an occasional small plain pimple (which is caused by external factors). Fast forward to this summer's heat wave. Active sebum production, sweaty workouts and what not. Given the durability (sad laugh) of my skin, it all quickly collects under the surface, into bumps/clogged pores/whiteheads. Which in turn are potential inflammations. Now I got a few healing pimples and lots of texture.
This product is definitely an active treatment rather than a moisturizer. But after buying it I can understand the confusion since it is very creamy and siliconey smooth, and a tube holds 40ml. I really like this consistency because you can layer it on spots that need it and it will stay there. The pointed "nose" applicator also helps (it's a like bb-cream tube). It does burn, especially on first application, but only in areas that burn often for me - around nose and under eye (just washing off sunscreen makes the area around my nose burn all the time, I think it's because my nose is runny all year long). Luckily these are not the areas I need this product to work with, so I avoid them. I "draw" lines and dots on problem areas, massage them into skin and repeat where needed. I give it some time to settle and dry (otherwise wet product might end up in sensitive areas). Then I follow with other treatments (optional) and my moisturizer. This product reduces the texture and sucks sebum closer to surface so I can extract it where I really need to ("don't touch your skin" method does not work for reasons stated above - it will just stay there).
I think it's the combination of BHA, niacinamide and the product's consistency that makes it effective, because I used a thick BHA gel and it worked worse on my skin. Afaik the rest of ingredients are mostly thickeners. You know the The Ordinary zinc/niacinamide and acids - they are all liquids. Also, acids tend to be separate products from niacinamide, at least in more affordable options. I think LRP products don't wow - they just work if you know what you are doing. No miracles. But they won't ruin your skin for dramatic short-term results too, at least in my experience.
UPD: It's pilling, I guess due to niacinamide in it (TO zinc/niacinamide is completely different in texture but does exactly the same; looks like the reason why LRP decided to thicken it). Somehow I only noticed after using it more, or maybe I switched something. FYI my main moisturizer also has niacinamide, might be the combo of them. So don't rub it. Just put it where you need it and tap. Or mix it on top of moisturizer (I do this with salicylic acid treatments since BHA is oil-soluble, and it seems to work ok).