Pretty simple. You can find lots of examples of getting each sensor working by googling "site:github.com ESP32 SCD41" etc.
There are libraries which make it extra-easy:
SCD41: SparkFun_SCD4x_Arduino_Library.h
SGP41: SensirionI2CSgp41.h
LPS22: Adafruit_LPS2X.h
Take a look through the past HN discussions of this and similar air quality monitors. Can also search HN for chip names themselves (like 'SCD41'). Many people note that the sensors drift over time, and buying "calibration bottles" of low-concentration CO2 is a slight hurdle for many - they're not that crazy expensive, but they're expensive enough to be a bit of a block for some.
Sounds great!
I’ll give it a try and see how far I go. Do you know any discord channels where such folks hang out?
P.S. Apt username BTW.
Super easy, use esphome. There's a few vendors out there that sell pre built devices, and they usually make their configs available if you want to DIY it. For example Apollo automation.