He can't be dead, he hasn't had a gay sex scene yet!
This isn't exactly true. In Skyfall they had that line where he implies he's had gay sex while the villain, who's gay irl, rubs Bonds' legs.
I didn't think No Time to Die was too horrible myself. Definitely wasn't great although it had a few good "Bond" moments. The script was haphazard and the plot was often pointless or didn't make total sense. They threw away the chance to have good actors really shine.
One of the alt-politics site did a good analysis of the movie's relation to other Bond films but I can't remember what site it was.