It’s good that you realize this early on how important checkrides are especially if your goal is to fly for a living. I wish my instructors would have had the talk with me in the beginning! It wasn’t until I failed my commercial multi add on rating my instructor beat his head off the desk (literally lol) in front of me and said it’s going to hurt my chances getting a job at the majors down the road. That woke me up fast to the enormity of taking a ride.
Like others said, study as hard as you possibly can for them, leave nothing up to chance, and only take it when YOU feel ready. Don’t let any flight schools push you if you are unsure.
If you do fail one or two, you’re probably okay for the regional level, but it will be a little tougher getting on at a major-not impossible but you will need to have a bit of a stronger resume most likely