The era of scientists being celebrities is done for the simple reason that it's not possible for a single human to advance our knowledge. Breakthrough papers are published by large groups who build on knowledge created by even larger groups.

Also, science used to directly correlate with improvements in life standards. Nowadays we see advancements in science (AI, psychology) used to actively reduce the standard of life.