No, more like realistic. It's like how every kid wants to be an astronaut, but there are only 100 in the world. Or how every actor wants to be the next Brad Pitt but very few actors (dozens ever?) achieve that level of success. Creating a billion dollar, public company from scratch is something very, very few people have ever done. Getting rich (single or double digit millions) has been done millions of times and so although difficult, is a reasonable goal to pursue.
And the $$ is probably the least useful thing YC provides. If I had to guess, I'd say the most useful things they provide are (in this order):
(actually turned into its own post: