Welcome to JC, you made a good first step in the right direction seeking advice here. This place is a gold mine of great information and people here will give you solid advice, whether it's the advice you want to hear or not.
Definitely dip your toes in the water before swan diving into the deep end. Go to a local airport, take a discovery flight. If that peaks you interest, then start looking into the most economic ways to earn the ratings. If you are looking into a degree route, a two year program will cost more than your local flight school but being able to transfer the credits earned is a benefit of going that route.
I'm not sure how much you know about the industry, but do some research about flight training. Look into pt 61 vs pt 141 training, if that sounds completely foreign to you, I will include a link at the bottom for you to read.
As others have stated, on the outside looking in while working labor intensive jobs this career sounds great. However, it does come with its share of issues. If you don't have a financial safety net you can find yourself in a bad place pretty quick, training is very expensive and the wages are quite low to start. You have probably read that there is a pilot shortage and wages are on the rise, which is true. However, the low time pilot jobs are still pretty low paying when you consider the debt you'll be in. Another way to avoid that stress of debt is to find a good school that will lead to a potential job after completion as a CFI, a school that will pay for add ons and maybe even your intitial CFI once you earn your commercial. Some schools are now salary around 30k with incentives for productivity as a CFI.
If you have any more questions in detail shoot me a PM. I'm a nerd and love to talk aviation

Also, use the search function on here. There are many threads through the years that will answer questions that you have.
https://www.flyingmag.com/pilot-technique/new-pilots/flight-school-part-61-or-part-141