Towards Net-Zero Carbon Emissions in Network AI for 6G and Beyond