Should you study engineering if you don't have a high aptitude in math?

That said, all being true, where your math foundation is NOW will have a significant impact on your success in engineering. If you want any valuable guidance, you need to better explain what “horrible at math” means. What is your highest math and what sort of grades did you get?