We don’t know enough about what OP’s son has done to answer the EC question. “No leadership positions at school” points back at the common misconception that titles in hs are what matter. You have to look at everything he’s engaged in, see if it makes sense. He may show leadership in other ways. That applies to the job, too- it can matter what he does.
If it’s a small Catholic hs, does that mean no AP? Is there rigor to replace that and has he taken those courses? Does he know what his major may be and has he pursued anything in that direction?
Getting into an Ivy is about more than stats and the finaid possibilties. I always say families need to really learn what makes each of the top schools tick, their values, and what they look for among all those tens of thousands of top scoring/top gpa kids. That’s not necessarily standing out to some odd degree. Some of the expectations are more ordinary. Don’t just think of good activities as padders or resume fillers if they are the right experiences.