What do you think is the status of the Enterprise in Picard? Is the -E still around? Or have they moved on to the -F? According to STO (which is semi-canon) the -E remained active until at least 2386 and the -F went into service by 2409. If Picard takes place in 2399, that would mean 10 years without an Enterprise. By 2386 the -E would be 14 years old. If I remember the TM correctly then the normal live span of a Starfleet ship is 20 to 30 years. My "head canon" has the -E substantially refit in 2387, expanding its "best before" into the first decade of the 2400s. Destroyed or decommisioned in 2408.