I write software as both a career and also a hobby. I’ve been doing this for many years and I still love it.
My advice to you is to go for it.
About your RSI — I have suffered with this for many years. I found that switching my keyboard to a new one would bring instant relief. The only problem is that the new keyboards were lasting me shorter and shorter times. I remember I was getting down to switching my keyboard every 11-13 days!
And then I found a permanent solution. I now go for a massage every 3-4 weeks with the focus being on my arms, neck, hands. Since I started this, I haven’t replaced my keyboard in 2 years!