Spiritual pleasures ⋙ carnal pleasures.
Yes, intellectual and especially spiritual pleasures are greater than carnal/sexual/bodily pleasures, St. Thomas shows in Ia IIae, q.31, a.5. This explains what attracts the religious to leave the world by taking vows of poverty and chastity/celibacy.
Spiritual pleasures more enduring
Fr. Garrigou-Lagrange, O.P.'s ...