Is it time for me to come to realization that going to a top tier university is not in my future?

You're right, you might not get into those schools but in the end when you look for a job they will only see a degree and won't care where it was from