Yeah you've got this! One thing to keep in mind is that Texas has some of the best odds for getting into a program- some of them as high as 80% acceptance rates if I remember correctly. The folks talking about 3.9 GPAs are generally applying to the west coast schools with 8-12% acceptance rates.
I started looking at nursing schools with a 1.9 GPA. Really. I got in to 2 of the 3 schools I applied to on my first round of applications (at schools with 8% acceptance rates!). Similar to you, I had failed my last college course in 2014 to get to that 1.9, then gave up on school for a bit. Since going back in 2019, I put absolutely everything into getting straight A's. After a couple prereq terms with A's, I was able to go back to my previous college and apply for academic renewal, where they scrub F's (and sometimes D's) from your GPA. I had 23 credits removed this way, bringing my listed GPA up to a 2.8. I've attached a photo of what one old term looks like on my transcript now. Any school that just takes the provided number off the bottom of the transcript now uses the 2.8 to calculate my cumulative GPA, while those that calculate it themselves can choose whether or not to include the 'renewed' credits. If your old schools have a similar process I highly recommend you use it!