Can serverless real-time databases replace large relational based systems?

Being that one of the big topics for freelance work is porting systems back to relational databases, i still encounter companies wanting to drop all server-side and go full on firestore, and cloud functions. I usually advice against it. Am I wrong?