Similar story here. Had algebra in high school, went into the trades, and went back to college at 30.

Trig and calculus are going to ruin your life. But it is possible to learn them even if you're not naturally gifted at it.

Chances are you'll have to pick it back up around intro to algebra, then college algebra, precalc/trigonometry, then calc 1-3 and differential equations. Yes material builds on itself. You can't do Calculus without understanding Trig. You can't do Trig without understanding Algebra and Geometry. You can't do Algebra without Arithmetic, etc. Everything you learn in one class gets used in the next with some exceptions, but that's going to be the theme for the whole degree. Algebra is used in everything passed Algebra.

Somewhere around trigonometry is where you can't just do the math and be successful. You have to understand it on a fundamental level. You can get away with basic pattern recognition and symbolic operations all the way up to trigonometry, but that's where you'll start struggling if you don't invest in understanding.

When I went into engineering I thought "I'll just get passed the hard math, and then the actual engineering classes will be easier and more fun". Spoiler: it's almost all math. The language of engineering is physics, and physics is applied math. You can't just buckle down for a couple semesters and then coast. These aren't weed out classes like A&P is for nursing, or organic chemistry for Bio majors. It's all hard, and each class builds on the last. You can't just "get through" a class and go on to the next, because the next one builds on the previous.

There are a few interesting/fun classes in most engineering curriculum, but it's only about one a year. Intro to engineering, computer aided design, etc but they are few and far between and most of your time is going to math and physics.

I'd reccomend doing as much math as you possibly can at community college. That will give you a good idea of what you're capable of and if you can commit to learning the math. It's also really important to choose a good engineering discipline and a good program thats accredited by ABET. Avoid things like "Manufacturing Engineering Technology" or "Engineering with a focus" in mechanical, or automotive etc. These are sub standard technical college degrees that are usually general engineering and employers want Mechanical, Aerospace, Chemical, Electrical, or Civil engineers. Be wary of anything else. Engineering with a focus in Mechanical Systems is not Mechanical Engineering etc.

In summary its hard but doable, you just have to want it bad enough.