"It will serve as an example to gay people that there is no shame in declaring yourself to have ss attraction."

Sure, that sounds great in theory, but like most theoretical things is unlikely to happen. Since the church still officially teaches that being gay is "objectively disordered" and "intrinsically evil," thereby intentionally instilling shame in those so "afflicted," few priests will ever admit to being gay if they still want to collect a paycheck, which the vast majority need to do in order to survive in this cold, cruel world. Even on National Coming Out Day (whenever that is) such a mass exodus from the priestly closet is highly unlikely. Now if the church were ever to change its tune in terms of doctrinal teaching then I suspect such an exodus is more likely, though it would probably begin more as a trickle  than a deluge.