Ok you want to improve, there's lots of stuff on that and I think you should keep pursuing that. HOWEVER don't keep beating up on yourself about "I'm bad", if you don't believe in your ability to play this game you'll lose a lot more often. Analyze where you're going wrong but also think about the things you can do and enjoy what you can achieve. It's an interesting balance but I realized a while back that I was being overcritical about myself and it was causing me to not have the confidence to do things I could actually do. Tell yourself before every game "I'm going to improve this game".
As for warding and map awareness. Yeah play a support and I recommend going with a healing type support and remind yourself to ward, watch the map regularly, thinking where are the enemies and could they be incoming to my position. As a support you can sit back a little and focus less on the micro(well in the long term you'll want to do more than that as a support but you'll be able to do this and still help out the team) and more on the macro of things. This should help you get a better grasp on stuff like that.
Tips for macro: keeping track of generally where enemies and especially when you have no vision on them, giving them the benefit of the doubt and assuming they're incoming to you will help with getting caught out. Before playing a champ think "where do I want to be in a teamfight?" what is your role to provide to the team.
For example Ahri is a squishy mage who wants to be around auto-attack range away from the nearest enemy. Because she has useful cc and the potential to kite backwards she's probably best chilling near the adc and helping him kit backwards as well. Alternatively she would be in the front picking someone off.
An important thing I feel a lot of people ignore is the tactical side of League of Legends. So do you all go mid for the turret, head to dragon, baron, split up to farm? The answer to these things is to classify what things are worth and how your current actions will affect the game going ahead. Something I see a lot is people grouping up mid for 5v5s when there's no real hope of either side getting a turret, positional advantage, anything but everyone just keeps skirmishing around each other simply because they're only thinking about their next right click. Always try to think, if we're grouping for a fight then where should be group up so that if we win we can get an objective right after. While it is solo-que and organizing your team around this can be hard it's definitely worth trying to work on. Don't be afraid of making bad calls and try.(watching LCS can help with this) Often enough people will listen to you and this can win games. For example:
I recently participated in an online tournament with random teams. Our team wasn't really all that great compared to the opponents and every single game we played ended up with us falling behind by mid game. But we had the awesomeness of voice communication so I kept trying to organize us and make good calls. And there were two games where our win could distinctly be attributed to my shot-calling(everyone on the team mentioned it and I got gifted a skin for it). We ended up taking second in our division and it was a lot of fun.
So if you can work on your understanding of macro play then I think you'll definitely improve a lot. Even if mechanically you're meh(as I am).
Don't give up!