My experience is almost exactly 50/50 on being asked to provide a card upon checkin whether or not I use app check in.

If you forgot the card you can use any card you have and usually call back in afterwards to change the charge to the right card. Dunno about Marriott but Hilton has a specific department that deals with that and requires filling out an online form and they charge new card and refund the old one.