Did Marshall Applewhite really believe he was going to next level or was it excuse for m suicide?

It's what he believed, the poor schmuck. The presence of the Hale-Bopp comet was probably what triggered the insanity, ultimately. Bad bit of timing.