Amazing no one has mentioned Bridge to Terabithia (2007). The screenwriters disavowed the trailers, iirc. Looks like a cute kids fantasy movie, starts out leaning that way with a middle-school Manic Pixie Dream Girl, then turns hard into being completely real life and extremely tragic. 14-year old me was not prepared.