supermatt makes an interesting distinction there: if you're more interested in the practical/professional aspect, don't get too sidetracked in the theoretical side.

Computer Science is fascinating and wide, but if you're interested in reskilling into a new, professionally profitable sector, veering too much into the theoretical aspect can prove detrimental.

However, as you mention, your objectives will adjust the more you come to learn, so it's important to keep an open mind and read more widely than just the next necessary thing.

Just beware of ADD side-tracking you, and have clear road maos. (Speaking from personal experience there, I always have to keep a check on my direction during both study and work, lest I lose too much time without much benefit.)

Speaking of roadmaps to study, perhaps this site can provide an early guide, augmented by books and courses, for your chosen field:

https://roadmap.sh/

And don't let your age deter you. People who love what they do are rare and priceless in any age range. If a company doesn't want to hire you due to your age, then that's probably a company you wouldn't enjoy working for anyway.