This article in The Guardian is worth a read:
Rejection is the norm for authors. So why do we hide it? | Sophie Mackintosh
Sophie Mackintosh mentions “steadily getting rejected from every creative writing MFA (master of fine arts) I applied to, and then by dozens of agents,” but doesn’t specify how many times.
Her one published novel is The Water Cure:
I was rejected (or ignored) 750 times from 2013-2019, before attracting the interest of Hodder & Stoughton’s The Future Bookshelf submission scheme in July. I’m still waiting to hear back from them. I have a feeling that I won’t!
I’ll be slightly disappointed if they reject me, but not destroyed, for after so many rejections, I’m as resilient as a rhinoceros wearing Kevlar armour! I’m ready to self-publish on KDP Select, which will at least offer immediate feedback on the worth of my Cornish Detective series.
There’s more than one way to climb the publishing mountain, so don’t be discouraged.