Most schools, if asking for any, ask for one or two - and some will say, an optional third one.
I think in many cases, kids get letters from teachers that don’t know them outside the classroom - hence you should have a resume or brag sheet to give them.
I think having 5 is too many - but I would see what each school allows.
When you have five, you’ll have to pick and choose which to send because most won’t want that many.
You’ll never know what anyone writes (nor should you) and you might think the teacher that likes them best might be the best letter and yet you might be wrong.
My guess is - in many (not all cases) they are used - but it’s probably more likely for if they are a good egg vs. a nightmare.
A lot will depend on your school list - if you have one yet. I never saw anyone ask for more than two with an optional third. But you should have two academic, maybe a 3rd (like a coach, employer, or other teacher) and beyond that, is overreach.
I think my kid got a third academic only because teacher #2 took forever and ever and ever to get it done - and we had to hedge the bet.
Good luck.