"It's going to become much more difficult to support yourself via creating content if step 1 becomes "be famous"."
You don't have to become famous. One of the things I love about Patreon are how some of my obscure things nobody has ever heard of are now providing a low-to-mid-grade middle class lifestyle for people you've probably never heard of.
Wander around a bit on https://graphtreon.com/ , and bear in mind a lot of what you see is hobby work, not attempts to make a living.
And also bear in mind there is no option where anybody ever just wakes up one day, decides "I'm going to make a living as an Internet content provider!" and a thousand people pour out of the woodwork to give them $3 a month right away. The question is not whether Patreon successfully thrusts success on people... the question is whether it enables it.
i.e., if I love Patreon so much why haven't I switched to make a living on it? Well, I have a realistic view of my own "content creation" skills and realize that it's not really an option for me. Patreon isn't going to magically fix that for me.