I initially missed @grobasoz response so was out of sync on the thread.
It looks like it is confirmed that it is not practical to run the xiao with a non-rechargable coin battery such as CR2032 or CR2450.
It would be nice if this was more apparent in the wiki.