This is either incompetence or maliciousness on behalf of the CDC, WSJ, or both. Life expectancy in the US is falling, but it's only falling due to Simpson's Paradox [1].
The CDC's own data [2] shows life expectancy increasing for all genders and races except black men, which decreased marginally over the last few years.
The primary reason life expectancy is falling is due to changes in the racial composition of the population, not because of opioids or suicide.
[1]: https://en.wikipedia.org/wiki/Simpson%27s_paradox
[2]: https://www.cdc.gov/nchs/data/nvsr/nvsr67/nvsr67_05.pdf (see Figure 5)