If you want to target river rafters then you can just target people with "river rafting, outdoors, adventurer, travel" interests, or followers of your page, or upload emails of existing customers. Then let Facebook find similar people automatically. It's that easy.
Everything else being equal, targeted ads still do better than non-targeted ads. I don't see how this is so controversial.
That’s the thing, it’s very easy to advertise to existing customers, worse your competitors are likely to bid up any easy associations. So, the most common case ends up in failure. Perhaps you didn’t something that works you can double down on, but that’s in practice extremely rare these days. Far more common is to realize after the fact you just spent a lot of money on a negative return.
Targeting people who have obvious self-selected and data-driven interests in what you're selling is going to do better than generic ads with no specific audience. This is practically science at this point. However nothing is guaranteed and a specific campaign not providing results doesn't have anything to do with the concept of targeted advertising.
Putting up a large sign outside convince store is going to target people in the area well enough. Giant companies like Disney can easily produce different ads to target individual slices of the population for similar results. But, how well can a small river rafting company for example leverage demographics data? Meanwhile because some companies find this data useful they suddenly need to pay a premium, which just doesn’t seem likely to pay off on average.