This heat is common to anyone not doggedly chasing college rankings to the very end. There are kids all over the country getting quizzical looks for picking better programs at "lesser" schools, or "settling" for financial reasons, or trading prestige for staying "too close" to home. Remember that Purdue severely outranks Yale (in engineering) and Missouri is a top school in the nation (for journalism) and your list matters more than whatever criteria Fiske or USNWR or Forbes is using this year. You have a particular set of priorities and got into a school that aligns with them. Best result possible, it's wonderful you got accepted to a couple excellent options and you have clear feelings about which you prefer. So if this is your dream then just say "Dreams don't read USNWR rankings" and move on.
As far as moving on, know that regardless of your choice you won't be seeing these people again. Caving in to other people's parents' expectations and picking Stanford won't matter to them any more than choosing USNA. This is just a stage in graduating from high school, so from here you're just going to move ahead and not discuss the subject again, that holds true for everyone. This is normal, if uncomfortable, and should be easier to ignore. But these people are frequently family or parents of friends who you've been raised to respect and try to please, so it can be hard to discount their opinions. Welcome to adulting, where not all paths run in parallel and not all choices can follow the same flock instinct.
Finally, when you get into any school a bubble forms that cuts off many old ties and replaces them with new faces, classes, clubs, teams and relationships. It's particularly explicit at an SA, but I know families that go weeks between contact with their kids who attend a college five blocks from home. Trust that you'll find a new life that'll feel very natural within a year. It might not be the same as high school, in fact it shouldn't if you grow and change, but it'll reflect who you are at that time and from there you'll go on to the rest of your life. Don't look back, don't wait for applause, just keep your eyes up, your feet moving and your mind open to the journey. Good luck.