> is AI denoise really just removing noise from an image...

This is why I like Darktable's profiled denoiser. It works by using a noise profile measured with a deterministic process using the camera you're targeting. In short, it's tailored to your sensor by profiling your sensor.