Foundation for oily skin and huggeee pores??

I’ve been using Fenty Beauty. I hardly wear foundation so I thought I’d give this a try. I went out with my mom to dinner and shopping the other day and not even 2 hours later I could just feel it. Almost like it was melting off my face. I tapped my nose because it was itchy and a huge patch came off. I use primer and powder and when it’s first on it’s beautiful and smooth and matte but after that it because a oily shiny mess on my skin. Along with my huge pore which become craters by the end of the day. I have some acne scarring and big pores on my cheeks. I just want to feel beautiful again. pregnancy is giving me horrible dark circles and hormonal acne. I just wish my foundation would last more than 2 hours without shifting and becoming so shiny. Any ideas for a super oily girl with textured skin?