The San Francisco 49ers tight end and his wife purchased their home in late 2024 and worked with Pottery Barn to transform it into an off-season retreat