From your source:

> Effective pile management and aeration are key to minimizing CH4 emissions.

So it sounds like a correctly managed pile is not a problem.

Also, I have a hard time believing my composting in my backyard is in any way worse than my sending the same food scraps to a landfill.

So are humans (we breathe out CO2 constantly!). A process emitting greenhouse gases is not an inherent reason to eschew it, so long as the entire end-to-end process isn't net-positive.

Use that compost to fertilise a tree, and you are still net negative on carbon, versus sending those food scraps to the local trash incinerator.