I stand corrected in terms of the Ts&Cs, which are here for trip interruption or cancellation https://www.americanexpress.com/content/dam/amex/us/credit-cards/features-benefits/policies/pdf/Trip_Cancellation_and_Interruption_Insurance.pdf
this does distinguish weather; however only prepaid hotel charges are covered, no show charges in general aren’t prepaid.