I'm a bit confused, because MDN ::after says in the accessibility section:
Using an ::after pseudo-element to add content is discouraged, as it is not reliably accessible to screen readers.
which contradicts the article saying ::after content gets included as per spec. They conclude though with
While it’s good and certainly useful that we can now provide alt text for CSS generated content, I do not recommend using CSS to insert meaningful content into the page.
Not only will some of your screen reader users miss meaningful information when the alt text is not announced by their screen reader (looking at NVDA with Chrome 👀), but there are also other reasons why inserting meaningful content in CSS is not yet recommended…
so I assume it's a spec vs real world thing.