How did it end up like that with the nose up: what is holding it up?
Google "weight and balance" if you'd like an in-depth answer.
Front fell off, people deplaned (while still horizontal) which shifted the balance backwards. It’s sitting on the rear bulkhead,
Gravity. The aircraft is heavier at the back, where the engines are. With the nose severely damaged/missing, the centre of gravity has shifted aft, so what’s left of the nose is sticking up in the air.