I don't think the decoupled architecture — the headless sites — is right for everything. I think that they are right in certain situations, but as I am quoted as saying, they are probably a regression for many of the people adopting them. Actually, I had a really good debate about this at the Netlify JAMstack conference with Matt Billman; but I guess it was too good, because they elected not to post it, but perhaps you could track down a recording or something
This still remains the case — weirdly, this conversation between the two Matts, the two company founders and holders of the two opposite views regarding static vs dynamic sites, has not been released among the recordings of the October 2020 JAMstack conference.