Bhagavad Gita, Chapter 9, Verse 20

The knowers of the three Vedas, worshipping Me by Yajna, drinking the Soma, and thus being purified from sin, pray for passage to heaven; reaching the holy world of the Lord of the Devas, they enjoy in heaven the divine pleasures of the Devas.

This describes a real, genuine reward, just one that's honestly named as temporary, not permanent.

Ritual practice aimed at heavenly pleasure is treated seriously here, not mocked, but its real limit gets stated plainly rather than left implied.