ci: handle Debian Bullseye end of life (#6175)

* ci: pin legacy Clang jobs to Debian snapshot

* ci: move supported compiler jobs to Bookworm

* ci: move x86 install job to Bookworm

* ci: keep legacy GCC jobs on pinned Bullseye

* ci: link Bullseye snapshot steps to PR 6175