It is a very bad idea. The reason which people who stand in judgement over other people (e.g. judges, teachers, professors, etc) are granted tenure is to make them less tempted to bribery.

One way which professors are bribed these days is to do pay-for-play research papers. A particularly good vehicle for this is "meta-analysis." There are meta-analysis papers which purport to prove that, say, masks don't help stop an airborne-transmitted disease, or that vaccines don't work or are actually harmful....

Garbage in, sprinkle some "meta-analysis math" and...garbage out in sheep's clothing.

In a system which is so cutthrought, and in which brining in research grant money is so prioritized, the temptation to do these sorts of dishonest papers is very high.

Without tenure, there is no end to this kind of pressure. Professors will never feel comfortable pursuing long-term research, or even useful short-term reseaarch.