If engineering was well paid, frankly I'd still be be an engineer. It's a great job. However, the truth is there's more money in selling the equipment than there is in designing it. This is despite selling the equipment being far less technical, and far easier.
If you are not so good in mathematics then you should do petroleum engineering as it is more concern with chemistry and physics. Environmental engineering is also a good option for you.