Seriously, I doubt it would even take that long. We get used to shit so quickly, and the news cycles have to keep feeding us new things, the only way we’d keep talking about the aliens if they kept doing new and interesting things. I’d be willing to bet a year later there would be some people who straight up forgot about it. “Oh yeah, aliens! Are they gonna, like, visit at some point or just keep exchanging calls with the Whitehouse?”
I know what you mean. The church is usually the last to recognize new realities so if they are open to it that definitely says a lot about where the Overton Window is.