https://danieldk.eu/hardware/smart-home/esphome-senseair-s88
If you want something with a display that works on batteries without spending over 200 Euro for an AraNet, the SwitchBot Meter Pro CO2 is pretty good option. It is regularly on offer below 50 Euro. It uses photoacoustic NDIR, but does not deviate a lot from the S88. You can use it without a SwitchBot by configuring it with a phone on Bluetooth. The meter works on external power and battery, but even when on battery, you can set the reporting interval to 5 minutes, which is good enough in practice. The meter broadcasts the measurements with Bluetooth LE, so if you want to get the data in Home Assistant, you can place a ESPHome Bluetooth LE Proxy in the vicinity [1]. This is an ESP32 flashed with ESPHome that listens on Bluetooth LE advertisement and forwards them to your HA instance over WiFi. Of course, you could also get the SwitchBot Hub, but what is the fun in doing that? :)
I would avoid the Ikea ALPSTUGA, it uses a thermal conductivity sensor, which is a very indirect method for measurements and it's often several hundred ppm off.