Photophysics and dynamics of the lowest excited singlet state in long substituted polyenes with implications to the very long‐chain limit