I think that perlmonks.org is running in perl CGI + mysql

You're wrong. :-)

why can't it use mod_perl + mysql?

It can and it is.

please tell me the pros and cons of this issue.

mod_perl is much more efficient CPU-wise, especially for a site with such heavy traffic as perlmonks has.