Your problem is not that you are a do-nothing loser, your problem is that you are (1) disorganized and don't understand risk (2) in love with the theory of financial freedom, not the reality
Regarding the first problem. There is a set list of things that need to happen for you to become a real estate investor. Depending on the area you invest (long term rental, short term rental, BRRRR) that list has a lot of overlap and is pretty undisputed. For example, before I started buying remote long term rentals
- Eliminate all personal debt, set a limit on what part of my wealth I want to invest
- Educate myself on long term rentals
- Obtain a HELOC so I have additional capital, opportunities (this was the part of my wealth I was investing)
- Find a property manager
- set property requirements for properties
- analyze properties, etc...
It is a step by step list of what has to happen in order to achieve a final goal, in this case of owning a set number of long term, remote, hands off rental properties. Implicit in this list is an acknowledgement of the risks and benefits and tradeoffs of this plan. Again as an example, the benefit is a regular monthly income in retirement, the risk is that the cost of ownership will be more than the revenue (mitigated by using only 1/2 the HELOC so a lot of capital remains), and the tradeoff is that I am leaving money on the table by paying off the mortgages in 10 years (to increase cash flow) and that by using a property manager I am hands off, but I am not maximizing returns. In short, the longest journey starts with a step and a map. Create the map and start taking steps
When you write down the risks (fears) you can define and mitigate them. That changes it from an emotional decision to a logical one (yes I am an engineer). Once you have them actually in front of you you can mitigate them or accept the them. I was not thrilled that I had 6 of 8 doors that I bought in renovation when COVID hit. But while no one planned for a global pandemic, I had capital reserves in place for the unexpected, which it turned out I didnt need and they rented just fine. But without that mitigation and planning I would have been reacting emotionally instead of logically. I have fears like everyone else, the difference is I thought them through beforehand.
Regarding 2 you are reading these books and they are "building the why" inside of you. If you want to convince someone of something the first thing you do is "build the why". Tell people why they should love it. Passive money, spend time with family, use other peoples money....it all sounds great. But if it was easy then the vast majority of workers would not get all of their income from W2 jobs. The truth is that it is hard, risky, and requires discipline. It is much harder than just having a job, that is why 99% of people live off jobs and very very few invest and quit.
In a country where 60% of people dont have $1000 in cash it is blatantly obvious that most people are unsuited to try. I honestly tell most people to just invest in an S&P 500 index fund for 40 years and work your job. It is a lot easier and has a much higher chance of success for most people. I dont know you, only you really know you. So decide, are you the 1% that is willing to work harder, risk more, and remain disciplined to succeed. Is the "why" enough to get you to take the risks and make the sacrifices? The stats say no, the stats say you are just a guy with a dream but no ability to do it. But while it is statistically rare for lightning to strike, it strikes the earth every day. Are you that rare occurrence.
Good Luck, I hope this helped you think about your problem in a different way.