Are LEGO display sets fragile once built?

It depends on the set. Specialist communities on r/legodeal and r/lego note that the 25th Anniversary Millennium Falcon is 'super fragile and not great for flying around,' while bricksfanz.com describes the Artemis SLS as 'surprisingly sturdy' thanks to a clad core. Architecture sets are generally robust once seated on their base plate.