That Celeron has SSE 4.2 instructions, so it might have all the “x86-64-v2” instructions.
No AVX2 is listed for it, so it will not have “x86-64-v3” instructions.
If one can run a Linux with recent glibc there (e.g. some live distro), then one can run
ld.so --help to verify the above. If that command is not available, then
a script like El9 will require x86-64-v2 support or manually check instructions listed in the script from flags in lscpu
The Rocky 10 requires x86-64-v3, so not an option.
The Rocky 9 requires x86-64-v2, so probably an option.
The Rocky 8 should accept almost any CPU.
Apart from CPU, the other part are all the hardware devices in the system. Each Rocky has drivers for some set of devices. ELRepo builds additional drivers for EL (like Rocky). There is a way (“inst.dd”, Driver Update Disk method) to install them already during install of Rocky, should the install require the device (i.e. usually for storage).
lspci -nn lists the devices in the system with device ID for each. Drivers do list device IDs that they do support.