I unironically wanted to get a career in CG while I was finishing up my degree. I always enjoyed the process behind world/narrative building.
I realized however that since I like CG work I really wanted to keep it as a hobby.
If you do something you love right and there is a potential, the money will come.
If you do something purely for the money, then your work becomes something you create so you can sell, and in turn from my experience the work suffers.
I have a good separate career where I can transfer my design skills, and I have peace of mind about my future for myself and my family.
Sometimes you got to pay your dues to do what you really want, and that is OK.