This is an excellent point. The energy transition is more accurately an energy addition. Some renewables on top of a still-increasing pile of burning fossil fuels.
Same with EVs. More are being sold every year but more ICE cars are being sold, too.
Until the fossil fuel industry actually shrinks, things are hopeless.
Locally grown is not always the best for the environment. Eating California rice in California is worse for CO2 than Thai rice, because California rice needs more inputs. Same with growing tomatoes in a natural-gas heated greenhouse in cold climates vs. trucked in from where they grow in the field. Transportation is a very small part of the CO2 footprint of food.