Yes, it is official position, confirmed in a few documents by Pope John Paul II (google "Fides et ratio"). But of course you can still many priests arguing against that :)
Religious texts can be revered studied like mythology (because they are). Critiques of biblical literalism are already fairly old-fashioned and surprisingly unnecessary.
I have a very religious family, which was uncomfortable for me when I was younger. But, that didn’t last long. Once I began studying more art history, mythology and theology, the ‘Us vs. Them’ around the topic has largely dissipated. I participate in all the happenings and have helped my cousins of similar age in contextualizing it all. I feel like I am ushering a healthy shift forward and new atheism now feels old. I’m open to critique of this, of course.