Q.What’s Wrong With My Night Blooming Cereus?
The Stamms have started to grow this tan overlay tips of the leaves seem as though they’re burnt and some of the thick leaves are becoming limp instead of thick and hard help this plant was thriving and all of a sudden has stopped thriving.

Certified GKH Gardening Expert
It looks like a pest is on the plant stems, possibly scale. Here is how to help:
https://www.missouribotanicalgarden.org/gardens-gardening/your-garden/help-for-the-home-gardener/advice-tips-resources/pests-and-problems/insects/mealybugs/insect-pests-of-cacti-and-succulents.aspx