"So, really, I’m an idiot for doing it because I should have known all this before going into it."

That's being too harsh on yourself. Most people fall into the trap of trying to "do what you love." You're not alone. The only real question is when do people realize they can't possibly make a living from what they love, and when do they get out. You waited longer than most, but you also realized it and moved on. How many out there are still chasing after dreams which they will never realize?